-
Time Zone Changing when forms submitted
Hi, I have created a few workspaces that are grids with the information coming from forms that are submitted every hour. All of my formulas and equations seem to be working correctly but am seeing an issue where the time zone constantly changes back to Pacific time when new forms are submitted (I am on eastern time). My…
-
Finding Next Closest Date of Children
Ok hive mind - I haven't been able to talk this formula out with someone yet, so I am looking for a little help. I have the formula that will fill out the children of my FINAL DATE column, but to fill out the parent row, I want my formula to look at the children of the NON REFUNDABLE DEPOSIT column, and tell me what is the…
-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
Sending an alert if any one of multiple columns changes after a deadline date
It doesn't appear that Smartsheet has an ISCHANGED function so I am struggling with an alert request. The request is for an alert if any one of 18 different columns has a value change after a deadline date. I guess I could create 18 Record Date automations on 7 different sheets to accomplish this, but that seems like a…
-
What type of formula should I use?
I need to add a specific start and end date dependent on which week # is selected in a "request update" form. For example, if "WK40" from the "WEEK #" column is chosen then "Start Date" would be 9/28/2025 and "End Date" would be 10/02/2025. The problem is that this is for a quarterly report, so there would be 14 weeks with…
-
My dashboard users are unable to view some of the charts, however I am able to view them correctly.
My users of the dashboard are getting the below error for some of the charts, however I am able to see them correctly. Please advise what is the solve for this error.
-
find manually entered duplicate lines
I have a sheet that contains practice-name, practice-seq,and coach-id. I have somehow added multiple exact duplicates. there are 8500 entries so its hard to find them….is there a report I can run to just show eact dups?
-
INDEX COLLECT MIN
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
-
Count of Distinct Users in a Date Range
I am working on a metrics formula. It worked when I wrote it, I was using the data in a graph, which worked, I changed the graph type, and suddenly the data went to zero. Now, all o my formulas set up like this are all returning a value of 0. Trying to determine what went wrong. I am attempting to count the number of…
-
Parent/ Grandparent Cell Value
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.