-
determine total % project completion using average
I am trying to calculate the % complete of a project across multiple smartsheets. I am using formula: However, it only winds up counting the %values in these cells. For example, the first project is 9% complete, the second is 1% complete, so it returns the value of 10%. if you average these percentages, then the value…
-
how to use vlookup and if functions
Dear Smartsheet community members, I need your quick support please. I am trying to pull the data from a sheet which is filled by operations team to the annual plan sheet. The task is to pull the actual contract values from Sheet of operations based on contract IDs to Annual Plan sheet. the complication is each contract…
-
How can I use the SUM function in a column, but only add/account for numbers that are in child rows?
Is there a formula that I could use to SUM numbers in a column, but NOT accounting for values that are in parent rows? The formula would go on a sheet summary; the reason not to account for values in parent rows, is to avoid duplication, since they are a reflection of the information in their child rows. Thank you!
-
Comparisons of dates(Committed date,New Committed date & Actual Completion Date)
Hello I have 3 dates column in smart sheet i.e Committed date,New Committed date & Actual Completion Date I need to compare these dates like if Commited date is> New committed date then i should get some color & the same way if committed date>actual completion date then i should get color & the same if New committed date…
-
Date and SUMIF or SUMIFS formula
I could use some help as I am not savvy with formulas. I have this long formula that references another sheet to calculate production credit by "assessors." This formula works fine and it calculates the entire sheet. I currently use this formula to calculate annual production credit. =SUMIF({Production Credits_Sheet2 Lead…
-
Project Management: Automating Timelines Across Multiple Projects/Sheets
Before I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't have LiquidPlanner nor does it plan to, it's just the only product I've heard of that has this functionality out of the box.)…
-
Formula to lookup and display date based on specific task
I need to report a GO Live date on various dashboards. The problem is the go live date is not in a static row and can move up or down in the project plan based on tasks. I assumed that I could use the vlookup to find the "Go live" task and display the date but using this formula, nothing displays. I dont get an error of…
-
Adim Access causes Circular Reference Error
Why when I give someone Admin access to a sheet used in a lookup formula, am I getting a Circular Reference Error? And as soon as I change access to Edit only the error goes away?
-
Date Range Formula
Hi! I'm trying to say: If a date in one cell is between April 1, 2020 and June 30, 2020, then return "Q2" in this new cell and if there is no date listed, return nothing in this new cell. What is wrong with my formula? =IF([Date Visited]@row, <=DATE(2020, 4, 1) >= DATE(2020, 6, 30), ="Q2", 0)
-
Ignoring the empty fields
I could use some help with what I'm sure is very simple formula, but ya gotta start somewhere, right? I want to trigger a Red Flag if the Due Date is Today or later. This formula does the trick other than it immediately triggers a flag for all empty column fields. =IF(TODAY() > [Due Date]6, 1, 0) I know there is an…
