-
Delete all rows in Smartsheet using API call
Hey, I have a fairly large Smartsheet of about 500 rows which I am accessing through an API call. Is there a way to delete all rows in the sheet using DELETE API request without mentioning all the row ids separately?
-
#unparsable error on IF/AND statement
Can anybody see the issue with this formula? I've counted and there are 8 open/8 closed parentheses, and two criteria for each of the IF(AND( statements =IF(ProdScore2/HrsWorked2 >= 4.4, "Outstanding", IF(AND(ProdScore2/HrsWorked2 <= 4.3,ProdScore2/HrsWorked2 >=3.8 , "Very Strong", IF(AND(ProdScore2/HrsWorked2 <= 3.7,…
-
Notifying multip;e folks when a change is made to a specific ow
Hi We're a construction company and change orders are a nightmare when not tracked properly. We're working on a "from the field" change order system and I'm the sales/estimator. What I'd like to do is once I get notification from the crew that a change order needs to be generated, and then inform the bookkeeper, lead…
-
Count for Checklist with grandchildren
Hi All, I'm working on a large "checklist" that has children lines and grandchildren. On this checklist I have a completed column with a check box. So I was using the =COUNTIF(CHILDREN(RANGE),0) to get a list of all children lines that were incomplete. The problem is that as the list has evolved I now need it to do this…
-
Prevent changing last modified date by formulas with TODAY
Hello 'smartsheet', we are using some formulas including the TODAY-function. Example: * Mark a task as "overdue": =IF(AND([End Date]1 < TODAY(), Status1 <> "done"), "overdue", "-") * After that we use conditional formatting (red color ...). But now each day, a task becomes "overdue" the first user of the day is registered…
-
Merging a Trial Account
Hello, if one of my colleagues creates a trial account, can they move their sheets into their licensed user account once they are a licensed user on our team?
-
Sheet limit within Smartsheet
Hi everyone, I'm about to embark on a large scale server back up and am hoping to keep all of my data logs on Smartsheet for safety. There will obviously be a massive amount of sheets to hold and I was just wondering if anyone knew the limit on how many sheets you can host? I'm a licensed user and am part of a team…
-
Enable and Set Up Auto Logout
Is it possible to set Smartsheet up to automatically log off users due to a period of inactivity?
-
Enhancement Request: LOOKUP argument for default value
I would like to request an additional argument (optional) for the LOOKUP function for a return value when no match is found. The MATCH() function could use this as well. I know having two optional arguments may be a pain. Throwing an error would also provide functionality, but I don't want to suggest using an error message…
-
Can I set start date by status in card view
Hi, I'm wondering if it is possible to set the start date and end date using card view. The idea being that when I set it to In Progress, the start date gets set to today and when I set it to Done, the start date gets set to today. Thank you!
