-
Need help with a formula to look at multiple columns and insert a value in another column.
Currently I have the following formula in the Grant Status column to indicate active or inactive based on the end date. Now I need to add Deactivated as a status based on if the FY Start is NA. If NA is the value, then Grant Status needs to be deactivated regardless of what End Date is, whether blank or has any value.…
-
Workflow to trigger comms when number exceeded but not in between.
Hi, trying to work out how I can get a workflow to trigger only when certain milestone numbers are met. For example, I'd like an email comm to be sent once the sum of a column reaches 50, 100, 150, 200 etc. The number will be entered via a form, very basic, so for example 4 entries could be sent via 4 form inputs (15, 11,…
-
Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
-
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…
-
find number of days per month between 2 dates
Hello, i need help with the below I have many projects with cost that i need to divide: here is one line. start Date 02/10/2022 end date 05/06/2022 cost : $35,000 Looking to project the average cost between those 2 dates per month. solution: 86 days between start and end date 19 days in February x $406.97 ($35000/86)=…
-
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
-
Formula with range data
Hello, I'm looking to see if anyone knows a formula that would add owner income and co-owner income together to reflect in Joint Income column. I'm not sure how to do this with data in ranges. Thank you.
-
Smartsheet Automation for Request to update and Request for Approval
Hi, Can anyone experiencing not receiving any notification for Request to update and Request for Approval I am not receiving any even though the workflow, trigger condition is correct
-
Need to convert time entered to mountain time
Hello, I am working on a sheet where orders will come in across the country and list local time. I need to be able to convert this time to mountain time regardless of daylight savings time. Anyone have any ideas? Also is possible to convert to the time to military time if it is received in standard time? Below are my…
-
New entries to the Smartsheet don't include formulas
Hi all, New entries into my Smartsheet are not including the 2 formulas I have created. I have tried the troubleshooting which advised the following: Ensure the formulas are present in cells near where you want the new rows to appear. Check if the last row before the new entry is indented, and remove any unnecessary…