-
Strange INVALID VALUE error
Hi everyone, I've encountered a problem in Smartsheet that I tried solving for a long time without success. I was creating metrics for a sheet, and I made a bunch of summary fields that contained my formulas. They all worked as intended when I created them. About a month passed without anyone touching them, I went back to…
-
Workflow action to set a date to a relative date or static date
I am requesting a formula that would allow me to update a date with something other than today which is done with "record a date". I may want to record 3 days in the future or possibly a fixed date such as "12/25/2026". This would allow me to set fields that can be used for alerts while leaving them editable since they…
-
Workflow Action to increment a Cell value by some number
As a programmer there are many cases that I would like to take a number in a cell and add some value to it. I dont have a particular use case in mind currently, but this allows another tool in the box for coding complex systems.
-
INDEX COLLECT function returning #INCORRECT COLUMN VALUE
I have a sheet that contains the info of all of my employees which includes a column for their initials. The training department of my company has a sheet that I have view access to but not editor access. They track the qualification due date of all of my employees and I want to collect the due date on my employee info…
-
Calculating a percentage based on YTD wins
Hi everyone - I'm trying to add a percentage of wins to a dashboard. Initially I thought the easiest solution would be to add a formula to the sheet summary page and i used this but have been getting back #invalid Data Type error. =COUNTIFS([Status/Conclusion]:[Status/Conclusion], "Won", YEAR([Date Requested]:[Date…
-
How to add another calculation to an If statement and Index/Match
Hi, Hopefully this will be an easy one. My brain is going completely blank on this. I have a formula that is basically calculating/selecting one of three values based on which is not empty. It is based on the user checking the "Included" box to trigger an index/match formula to show the cost (Hourly, ,Unit or Fixed), and…
-
Column Dependencies and Formula Auditing
I wish there was a way to select a column/ cell and see all formulas and automations that reference it. Similar to Excel's "Trace Dependents" and "Trace Precedents." This could all be part of a formula auditing tool that would let you see all formulas on a sheet and which column they are in.
-
Date Formula Not Working?
I am trying to auto-populate some dates in my "Due Date" column. When a date is entered in row 5, I need row 6 to be "date" - 5 days. The formula I tried was: =[Due Date]5 - 5 But when I click enter, it just adds a " ' " to the beginning and displays the formula. Am I missing something? *Note, this is when using a date…
-
Auto-Populate Hours Column
I would like for my Hours column to auto-populate with a "1" when I put a resource name in the "Assigned To" column. I have tried the basic formula but it is not returning anything when I add in a resource to the "assigned to" column =IF(AND(ISBLANK([Assigned To]@row) = false, COUNT(CHILDREN()) > 0), Hours@row + 1,…
-
Problem with my formula,working for first part but not for the last part.
Hi, My formula works for the first 10,9 and 8 but for the others i get invalid operation. the formula is below . Time criticality is a requested go live date/ current date =IF([Time Criticality]@row <= 30, 10, IF([Time Criticality]@row <= 60, 9, IF([Time Criticality]@row <= 90, 8, =IF([Time Criticality]@row <= 120, 7,…