-
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…
-
IF FIND RIGHT String
Hello, I’ve been searching all over the Smartsheet community since last week and was hoping someone could offer some assistance. I have a long Status value that I need to auto populate a shorter value in another column. I really just need a contains formula but I haven't seen that as an option here. I could do this for the…
-
Create charts without hidden data
Is it possible to create a chart without including the hidden data?