-
Priority Rating with Formula Logic
New to smartsheets and the Formula and I am basically trying to set up a priority rating system. There are 4 priorities and 4 questions. If all questions are answered yes and the one checkbox is check then it gets a rating of P1 but if 2/3 questions are yes and the checkbox is checked then its p2 and so on and so on. I am…
-
IF statement
I am working on a sheet and want to incorporate an IF (or maybe an IF AND) statement based on the date items are submitted to them for review, which is one of the date columns in the sheet. Here are the conditions I want to test: 1) If today is less than or equal to 3 weeks from the submission date, turn the RYG ball…
-
Hiding Completed tasks
I'm using smartsheet to track projects and their coresponding action items. After tasks are completed, I want to be able hide the rows to make the smartsheet easier to navigate. Is it possible to hide rows? I can't tfind the functionality. Any help would be appreciated.
-
Smartsheet forms are still not WCAG complaint :(
I found that Smartsheet forms fail WCAG compliance using the WAVE tool due to the logo image lacking an alt-tag. In April, I asked about adding alt tags without success. Failing WCAG is a deal breaker for my organization. Is there any plan to add alt tags to the logos on forms?
-
Update Request with attachment
I've tried to send an update request to include the files attached to that row. I've selected "include attachments." However, the updated request does not send the attachments along? Is this a bug or am I doing something incorrectly? When I 'send' the row and select attachments, it works fine. Any help on this is greatly…
-
Nested IF Statement Formula
Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yellow, green) light flag formula to set the status of a task based on its…
-
Smartsheet Merge and cell images
I have a sheet that contains a column where I've inserted images. Is it possible to have those images show up when I merge into google docs? I tried but it errored. Do the images have to be a certain size or file type? Thank you
-
If criteria is xxx, duration is zero
Dear Smartsheet community, I have a sheet for staff to report time off. I have this formula to calculate the net working day(s) between begin date and end date. =NETWORKDAY([Begin Date]@row, [End Date]@row) However there will be occasion when staff will not be taken time off. Therefore, I want to add where column Absence…
-
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
-
RYGB - need to update Parent row with status of children
I am trying to get the Status in the Parent row to update automatically based off the Status of the child rows. I have the following formula in the Status column of the child rows: =IF([Phase Status]@row = "complete", "Blue", IF([Phase Status]@row = "At Risk", "Red", IF([Phase Status]@row = "On Hold", "Yellow", IF([End…
