-
workflow automation - rows aren't moving?
Hello, I created a workflow to move rows once a column status is changed to "complete" within any row. But the workflow didn't trigger, even when I manually changed the status to something else and back again, saved, refreshed, tried again. It finally worked when I moved the row to a different spot in the sheet (shifted up…
-
How to project a completion date with predecessors and durations
I am building out Engineering project plans. I'd like to be able to pre-plan the work out by using predecessors and approximate durations. However, if the first line item in the plan does not yet have an end date the predecessors/duration will not calculate to give a projected end date for the project. I had a call with…
-
Project Server 2016 - Project Health indicator error!
I created the health formula below to address the legend listed below the formula. However, I am getting an error in the formula, can anyone tell me what I am doing wrong and provide some assistance? IIf([% Complete] = 100, "Completed", Switch(([Finish] - Date()) < 75%, "complete within 45 days of finish", ([Finish] -…
-
LookUp and Match a value located in a cell with multiple values and return single and/or multiple va
Hi, I am hoping someone can help with this formula. I was able to get this working using VLOOKUP when there were fewer complexities. In Sheet 2 when there is a value in the "Lot Number" cell, * The formula should look at Sheet 1 to see if the "Lot Number" matches and exists in any of the cells located under the Lot Number…
-
Complex nested IF, AND with traffic light symbols
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…
-
Generate Cover Sheet Summary Page off of Data?
We have a spreadsheet listing all of our jobs and I was wondering if anyone knows if we can highlight one of the jobs by selecting it and generating a cover page summary report of just that one job? Any advice would be greatly appreciated! Thanks, Crystal
-
Ability to create folders in the attachments tab
Is there a way to create a folder in an attachments tab? We have versions of image files we want to see but would like to be able to create a folder for 'old photos' or something like that within the attachments tab to help sort/seg the attachments.
-
How to determine if a milestone is an extended milestone?
The formula value of [Duration]@row is a numeric value of 0 for both a Duration cell value of 0 and ~0. This means it is not possible to determine the number of work days that Smartsheet will then use for scheduling and % Complete calculations. Does anyone know if there is a way to determine which Duration cell value has…
-
Kickstarter Campaign
I'm interested in running a Kickstarter campaign and haven't done one before... has anyone on here ever ran a campaign for a tangible product development project and tracked it in Smartsheet? Would you be willing to share some insight and maybe some tips on setting it up?
-
ADD LAST COMPLETE DATE
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last column that changed to "complete" status. I really appreciate any help! Rob
