- Conditional Symbols $ to $$$$$
Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), "One", IF(Saving1 = MAX(Saving:Saving), "Five", IF(Saving1 = AVG(Saving:Saving), "Three", IF(Saving1…
- Separating weekdays from weekends
Hi everyone, this is probably something very simple, but I still struggle, hope you can help. I have a large timesheet with one raw per day, every day of the year. The contractors will get paid higher rates on weekends, compared to work days. Initially I thought of putting an extra checkbox "weekend" column next to the…
- Is there a way to create a budget template that automatically populates from a data sheet in Smartsh
Our company uses a single source data page that collects all project related information and also the financials. This page will include all completed and in progress jobs for Departments A-Z with no idents on the page (suggested but was pushed back). It would be ideal to create a report and have the new budget template…
- Can Smartsheet integrate with AP software, like Lawson?
We need a solution to integrate with out accounting software.
- Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
- Planned and Earned Value into Project
Wondering if anyone has done any formulas for either Planned Value (PV), Earned Value (EV), into their SS projects? I have all the costing,tasks, opex/capex.%Complete,dates.. in my projects and this would be my next step :)
- Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
- hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
- Scheduled email based on a condition - Request
首先,计划email across the entire platform would be a godsend on its own. Such as from a report. This way i can have only the information i want them to see is sent. Secondly, sending an email based on a condition. Basic example, if a box is check, send the email at such dy and time. Is there a better or…
- Template for Capital Raise
I'm new to the community and Smartsheet . Does anyone have a template for a capital raise or know of one that I may use? We're a start-up raising our first round and I need to keep track of to whom our investor docs have been given, who on my team introduced us and next steps. Thanks for your help!
