-
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ā¦
-
Formula for Resource Type, Resource Name and Year
Hello - We have set up a sheet to pull from a Master document to include Resource Type, Resource Name and Year. The Year is from a Helper column. Can someone review the current formula we have to identify where we went wrong to no pull "zero" as the result vs the actual number. Before adding in the Help Year and Reference,ā¦
-
How can I make FS dependencies start on the same date the predecessor ends?
Hi everyone, Iām migrating a schedule from MS Project to Smartsheet and I noticed a difference in how FS (Finish-to-Start) dependencies behave. In MS Project, when a task has an FS predecessor, the successorās start date is set to the same day the predecessor ends. But in Smartsheet, the successor is pushed to start oneā¦
-
Link existing table
Hi, I have a table which is linked to database and the table would have new row add. I want a table that have the same data and I can insert a new column to calculate the data. I've found some ways: Cell linking, Report, Connect Your First Sheet to a DataTable. If I use Cell linking, I need to maintain it manually. Report,ā¦