-
Predecessors - creating conditional workflow question
Probably Smartsheet 101 but seeking help nonetheless. I've already selected "Dependencies enabled" in the sheet settings. My goal is to restrict a column checkbox (called "Start [for a task]) from being selected unless the predecessor has been completed (a checkbox column called "Complete"). I'm not certain how to complete…
-
countif with dates
Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2018. Thanks =COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")
-
Backend Process for creating Workspace and Project Folder
Hello, Currently we create a new workspace for each projects even if that project has different Location, (ex. X Los Angeles, X New York, X Vegas) will have separate workspace. However, we want to create a one workspace for the same Project and have folder inside that for different location. So X will be the Workspace Name…
-
Any Smartsheet users from Chicago area?
Hello, My team is looking to connect with other Smartsheet users to share ideas on how we leverage Smartsheet to manage tasks and projects. Now that our department is growing, it is crucial that we refine our Smartsheet work space and how we organize our work in portfolio style for each team: operational tasks versus…
-
Multiple Email Address Entry Form Field
Hi I have a created a form, I would like the client to fill the field- Point of Contact- which is an email address. How can one enter multiple emails in a single form field? Any help is appreciated. Thanking you, Regards Saumya
-
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…