Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together…
I am having hard time to have a formula to obtain the health color for the task I have 3 columns: End Date, Circuit Quote% Status and Quote Health IF(AND( [Circuit Quote % Status]@row <=0.5, [End Date…
I created a column to be provide me the task (row) total % complete. The two columns below have a dropdown status that each represent a % complete The % for each status is below: =IF([2nd Circuit Stat…
I think this formula should be easy but I am terrible with formulas. There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for t…
I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the tot…
@Andrée Starå has mentioned on multiple posts about creating Helper Sheets when trying to manipulte data to have certain rows copied to other sheets. I'm completely stumped where to start with the cro…
Hello, Is there an easy way to send an automated reminder based on an approval request? We automate approvals from some of our Smartsheets and would love for a reminder to be sent x days later if the …
Hello! We are linking cells from a project plan to a master sheet. Every other cell in the row linked just fine, except for the last one. It says that it is linked, but no information is being pulled …
Hey all, I'm curious as to how others are utilizing the symbols for project health when tracking health task-by-task in a project. If you are using RYGB or RYGG, how are you indicating future state ta…
I'd like to truncate the Dashboard view for my users so that they can select what they want to see by Section Content (eg Project Progress, Project Resource Links, News/Updates etc.), instead of every…