-
Help: Status update from a reference sheet with formula
Dear, Can anyone please help me, I am trying to create a formula to generate a status update based on end date from a reference sheet (name: Cloud). =IF({Cloud Range 2},"Complete" <> 1, IF(TODAY() - [End Date] > 0, "Red", IF(TODAY() - [End Date] > -3, "Yellow", "Green"))))" I have added the header of the sheet I am trying…
-
Automating the generation of a number
Hi, I am trying to automate the generation of a unique number based on when an checkbox in a row is checked. I have a list of project titles in one column and checkboxes in another column. When I mark the checkbox in row 1 I want the number 1 to populate a third column. When I mark the checkbox in row 3 I want the number 2…
-
Check out/check in - Validating an inventory.
Ok, so I'm trying to use Smartsheet as part of our employee move process. Basically, in the past we've use a paper form to inventory what a person has (PC, monitors, chair, boxes, etc) and then use the same inventory to validate that the correct items arrive at the new location. So, I've created a sheet that will capture…
-
Limit Size of Entry on a form
I tried to search for this but was not able to find it. I have a form that I has one of the entries that I want to collect is nickname....but I can only display 8 characters.... So how do I limit the entry to restrict it to be only 8 characters? Today I am preloading the field with XXXXXXXX hoping that they will read the…
-
Alerts & Reminders for "Assigned to"
Can you send reminders for upcoming due tasks to someone that is "Assigned to" a task? Currently I just send the automated reminders to shared users but, recently I had the need to just send particular tasks to selected individuals that would not be interested in the majority of the other tasks. I am thinking the answer is…
-
Applying Formulas to Entire Columns
Hello there, I'm new to the community. Our company has adopted SS for projects and we're now looking to expand the use to HR, specifically starting with leave requests. I've started a leave request sheet based on the template below, with a few adjustments geared toward my company.…
-
Issues with opening some tabs in Smartsheet
For sometime I have had issues opening some tabs within our company smart sheet application. I had tried various ideas to try and resolve the issue. I have 4 tabs which I have been given access, in the beginning they opened just fine, it's in reason months I have had issues opening them. So the owner of the smartsheet just…
-
SSO usin SAML question
Hello Support Community. We have setup SSO using SAML and it appears to be working fine for licensed users. Unlicensed users on our email domain are asked to create a password (therefore a new account). Can I assume it is expected behavior that only licensed users will be able to take advantage of the SSO configuration?…
-
Dashboard Widget Dividers
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.
-
Webinar - Dynamic View
Hi, I´ve registered myself into Nov, 8th webinar, but I got stuck on ameeting. Would be possible to access the webinar video? Thanks
