-
Automate Harvey ball color based on multiple variables
I'm not sure if what I want to do is feasible or not so please let me know if I'm going off the deep end. I would like to have a Harvey ball change color based on several criteria/variables to show likelihood the task will, or won't be, completed on time. Has anyone made a formula that will show a red Harvey ball if the…
-
Multiple reference Formula
Greetings: Trying to create a formula that tracks task duration displayed by "symbol" in conjunction with another condition of the task:... complete, or not started. I was able to get the symbols to show up properly based on calculated duration. However, the bottleneck is related to the formula not picking up a symbol…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
-
Formula errors
* Schedule Variance:* Getting errors Invalid & Unparseable. * My best guess to those results. Are the other columns that it's looking at have cells that are blank. ( actual finish date) resulting from the fact that that task is not completed yet. Thus nothing to draw from * What I’m trying to have the formula pick up...is…
-
Alternative to create a Chart from data on a Report
After reading several discussions I am completely disappointed that I cannot create a Chart directly from a report. So I am looking to understand some alternative options. I have ONE master sheet that tracks ALL of our department project status'. What I needed was to track ONE teams projects - so I created a report so that…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Conditionally move rows with Zapier and a check box
Hello all, I would like to automate my time sheet approvals. I use the professional plan with zapier, which does allow multiple steps. I am trying to conditionally move a row when a check box is checked in the "approved" column. However, I cant figure out how to enter the selection criteria in the "custom" value portion of…
-
Linking pages
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
-
time sheets form
I want to create a form that I can e mail the link to my employees on site weekly to collect hours. Ideally include Employee Name Start Date of week Day Site from a drop down list Hours at site Options two sites per day. Note at bottom to advise on holiday , illness Thanks in advance Grant
-
Using a checkbox and an IF statement to perform a function
I have been using Smartsheet to track production and perform P+L on projects at a construction company. I am attempting to have the sheet calculate our percent profit on a project only if our GPM Report checkbox is checked for the job. Ideally I would like to incorporate this into some other calculations as well but I will…