-
Is there any customise manual for PMO establishment using smartsheet?
Is there any customise manual for PMO establishment using smartsheet? I have more than 100 projects that need to be monitored by reflecting plans, issues, risks, ...etc.
-
Alert with multiple dates
Hello, is it possible to alert someone multiple days within a project duration? Example: Projects have a duration of 3 months. Within those 3 months, I need to reminder alert every 21 days. Please assist. Thank you, Grace
-
IFERROR - Help, Please
I'm currently running the below formula in a particular column, and applying the colors to the visual symbols: =IF(Percentage19 < 0.75, "Green", IF(Percentage19 > 0.9, "Red", "Yellow")) It works great, however I can't stand looking at the "#DIVIDE BY ZERO". I've tried all combinations I can think of, but how can I just…
-
Automation - Request Update
Hi. I'm looking for help troubleshooting an issue I"m having with Automation in smartsheet. I set up a recurring request for updates to run each Friday at 8:00 AM PST to all Assigned To users in the sheet. The problem I'm having is my request automatically includes a form I created for project intake. I do not want the…
-
Update Requests
We have an automated update request created, however, when it is triggered it sends a link to update all fields that need updating to all contacts within the sheet - as a result they are not using it as they cannot see which action is theirs to be updated What we would like to happen is that the update for that row only…
-
Automate sending an email referencing a column
I have a form where the public submits information for a schedule change. Can I set up a workflow so when I mark 'complete' in a column, I can reference the column where the email is located to send out an auto response that their request has been completed? These are non-smartsheet users who do not need any access to the…
-
Move Row Workflow
I finally figured this out! Yay! But now the workflow moved rows even where the condition was not met. My Trigger was 'When Rows are Changed' 'When' was set to a specific field formatted as a Checkbox when I checked the box, several other rows with an unchecked box moved too? Can anyone help?
-
Assistance with IF AND Formula
Hello, I am trying to create an IF AND formula and get stuck after a certain point as I am a bit green when it comes to Smartsheets. What I am looking to have it accomplish in general terms: IF the status is set to High AND the Status is marked as Complete, then input Today's date in the Completion Date column. Can someone…
-
Nested IF
I cannot figure out why this formula does not work. HELP! Thanks. Suggestions: =IF([Complete]1 = 1, "B"), IF([Finish]1< TODAY, "R"), IF([Finish]1 >= TODAY(+45), "Y"), IF([Finish]1 <= TODAY(+90), "G", " ")))
-
New Multi-Select DropDown Buggy?
Has anyone else experienced the newly-released multi-select option being buggy? I seem to have 50/50 luck when I attempt to select from the drop-downs when it wont display drop-downs. I thought it might have just been me but then I had the (not) wonderful experience of showing my VP the new feature when it didn't work on…
