-
An error has occurred in Smartsheet Please log out and log back into the app before continuing. If
Hi guys, my team is receiving the following error An error has occurred in Smartsheet Please log out and log back into the app before continuing. If the problem continues, please request assistance at www.smartsheet.com/gethelp. Recently Open Solution Center. Help We already did the proper troubleshooting like clearing…
-
Automation Recipients Blocked
I'm updating automations for a Sheet I created and when I attempt to add three people to receive the email notification, I get the "one or more recipients are blocked" message. If I have two recipients, it works just fine. All of the recipients have been granted access to the Sheet with Editor - Cannot Share access so, per…
-
Values returned in sheets but report says #BLOCKED
Hello, I need some help fixing my sheet/formula/report. I have project sheets that all contain a formula to calculate a value. The sheets return the value fine but when i try and run a report for all/some sheets i get #BLOCKED. Even running a report for a single sheet that works, I still get #BLOCKED on the report. Any…
-
Trend curve/ Variation
Hi everyone, hope y'all good. Im a PMO here in Brazil and Smartsheet ir our standard tool for management projects. Im tryng to create columns what we call "Trend curve" when we see the variaton of the real execution between the tasks, but when we set the project, it is impossible to put some condition in the cell…
-
My risk formula for program row with child Projects progression is not working.
I am tryings to create a risk formula for Program that has list of projects as a child. Following are conditions to mark the project as either Green, Yellow, Red or Blue: Blue: - Project has progress (% Complete > 0) but hasn't officially started yet (Start Date is in the future) - Indicates early progress or a potential…
-
Feature: Enable Conditional Responses to Different Formula Errors in Smartsheet
I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR function catches errors but doesn't tell us what kind of error it is. It would be great if we could recognize different errors like #BLOCKED, #UNPARSEABLE, #DIVIDE BY ZERO, and others.…