-
Maximum number of cross-sheet references per sheet
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 about 90% of the way through and just encountered the below. The way my sheet has been structured makes it impossible…
-
Task Health
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]@row <= Today (7)), “Red” IF(AND([Circuit Quote % Status]@row >=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row,…
-
TASK % COMPLETE FORMULA
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 Status]@row = “N/A”, IF(OR([1st Circuit Status]@row = “Waiting to sign the contract”, [1st Circuit Status]@row = “Waiting for…
-
Total % Complete for 4 columns
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 the 4 columns: Formula I have is: =SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) +…
-
Calculate the right average for the columns
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 total % average complete on "Quote % Complete" column. If there is "N/A" either in "1st Circuit Quote Status or 2nd Circuit…
-
Helper Sheet Help
@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 cross-reference formulas to make that happen. I have a master sheet with a lot of columns, some of the data in the master needs…
-
Automated Reminder for Approval Request?
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 approval status is still "Submitted". I can't find where I can build a reminder based on the status change plus a number of…
-
Linked Cell Not Working
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 into the cell. The cells in the project sheet are filled out and linked out to the master sheet: These are the corresponding…
-
Curiosity: Best practice use of symbols for health on projects
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 tasks? Gray or Blue is being used to indicate "Not Started" tasks or future state tasks Gray or Blue is being used to indicate…
-
Is there a way to create a 'collapse section' on a Dashboard?
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 everything being available as a huge data dump a mile long. Is there a functionality to expand/collapse sections on dashboards…