-
Why is my formula UNPARSEABLE? Is it because of Dropdown Dependency?
It's a long formula - I want to make the number of starts in the "Current Status" column dependent upon the selection in the drop down from the "Contract/Grant Status" column: =IF([Contract/Grant Status:]1 = Submitted, "Empty", IF([Contract/Grant Status:]1 = Assigned, "One", IF([Contract/Grant Status:]1 = ELD Review ODE…
-
Rich Text Widget is suddenly missing Cancel and Done buttons and Scroll bar
Please see widget with title "In Progress Tasks." Here's the address: https://app.smartsheet.com/dashboards/fhmp8FhCp98HQfrj3RcH3mXpF9MCRvMv4Jv6p6M1 Andrée, please see the screen shots, one has the buttons but not the other
-
Project Cost Calculator Smartsheet
I am looking for a template in smartsheet that I can use to build costs for projects and training courses we conduct. I noticed that on the smartsheet website advertisement it says that smartsheet has the solution. My goal is to program some of our costs to do business with certain rates and then send forms to the Program…
-
Formula for a Flag Column Based an If/Or statement
I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for Revised Analysis End Date). The flag should turn red when anything other than NA is selected. If NA is selected, then no red…
-
Enterprise Account login
A while ago, our account was merged into a company enterprise account and all existing sheets I believed transferred over. Account administrators changed etc. If I want to add new users at the same company to Smartsheet can they just click log in using your company account or does someone have to add them as licensed user…
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
-
Supplier Management - Template
Hi, I cannot find a pre existing template in smartsheet templates Do any smartsheet users have an existing template on their smartsheet account for Supplier/Vendor Performance or Evaluation, preferably with pre defined criteria, and pre formatted score chart and graphs? If so, are you happy to share this template? Thanks
-
RYGG Ball
Hello I have looked through the list of current Formula but cant find any that matches what I am trying to do (see below): If task due date is > 2 days from current date (today) AND Status is NOT STARTED or IN PROGRESS then flag the Green ball If a task due date is < 2 days from current date (today)AND Status is NOT…
-
Editing uploaded files
I am project managing construction jobs and have been given the task of auditing contractors whilst they are on site. I have uploaded the audit forms onto smartsheet as an attachment and I was hoping to edit them while I was on site without downloading them and re-uploading them. The files I am uploading are word…
-
Hiding NULLs in imported dates
I am importing an Excel with some NULL dates. How do I display empty cells instead of NULL? Thanks!