-
Alerts for Blank Fields
I want to create an alert or reminder when a field on a certain row is blank. It can't be a required field because the data is entered after the row is created. Does Smartsheet have this functionality? I don't see these options available today but thought I would ask if others have attempted this. I am currently exporting…
-
Nested IF statement for RYGB only works in one row
Has anyone come across a scenario where your nested IF statements work perfectly on one row, but when dragged to other rows don't apply the conditions correctly? I've added the following statement to row 47 of my sheet: =IF([Percentage Complete]47 = 100, "Blue", IF([Percentage Complete]47 < 33, "Red", IF([Percentage…
-
Hidden sheets in a Resource View
Hi I have a Resource View and some resources are shown 150%, as they are mentioned in a long-forgotten sheet (displayed here as "Other sheet") that is not maintained anymore, not shared and the owner is unknown. How can I figure out where this particular resource is used please? Thanks Attila
-
Auto Populate Due date
Hi, I manage to get SS auto populate the due-date base on the start date. But is it possible to make the due date calculation is not including the weekend? Example: Start Date = 19 May 2017, Friday Due Date is after 4 day of the start date, it should be 23 May 2017. But becasue of the Sat & Sun, the due date should delay…
-
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?
-
Managing Tabs in Smartsheet
Hi, I have 2 queries regarding the tabs in Smartsheet 1. Pin tabs - Is there a way to "pin" tabs within Smartsheet in a similar way that you can pin tabs in a Chrome browser so that those tabs that you pin are always displayed and don't get moved to the "..." list? I have a core set of sheets/reports that I would always…
-
Workflows for Alerts
I've been asked to come up with a way for smartsheet to send an automatic reminder to "Assignee" two days before the target date. This is no big deal and actually very simple to set up; however, the second part is "if the date completed field is empty and equal to or greater than the target date". I attempted to do this…
-
#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,…
-
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…