-
I have a parent row that needs to populate with appropriate 'Status' based on it's children
I have many parent rows with many children, in some cased grandchildren. Each child (or grandchild) has a status. Status choices are; Not Applicable Not Started In Progress Complete I have to account for the following possibilities; I have been able to write a formula for the first 4; I am having great difficulty writing…
-
Creating a Daily Total Sheet from another Sheet that Updates Daily
Hi all, I am having trouble finding the best practice for this and thought it might be easier to ask here. I have my "Main Data" sheet that gets replaced daily through a Data Shuttle workflow. I need to create a helper sheet that totals the count of one of the columns and keeps track of the totals for each day. For…
-
Linking External Sheets for Conditional Formatting
I am currently working on conditional formatting for a spreadsheet that connects to several spreadsheets. We have a Master Log (spreadsheet) that pulls project dates from multiple Project Schedules (Gantts) so we can keep track of project timelines of milestones. We have roughly 45 fields. 17 fields are linked to Project…
-
I am trying to create small chart for dashboard
I have a master sheet that has 100 projects all different end dates. Trying to find a formula or method create small chart like a sample Jan 2022 - 4 Feb 2022 - 3 Mar 2022 - 4 Etc...
-
How to use a formulas to indicate current constellation in sheet summary
Hi guys, I have a sheet to indicates constellations by date, and I cannot find a formula to get current constellation based on today's date, can anyone help with this? Much appreciate!
-
IF Formulas including Blanks and AND / OR
Hi I'm looking for a formula that will show me whether a deadline has been met. My Deadline Met formula is currently only taking into account the Agreed Deadline Date and the Date Completed =IF([Date Complete]@row <= [Agreed Deadline]@row, "Yes", "No") However, what I really need it to do is also check if a). There is a…
-
IF(AND Formula + substraction
Hello! I have the % Burn Rate of my project and the % Complete, I want to subtract and according to the difference in them I want Harvey Balls to display different colors. If the difference between the % Burn Rate and the % Complete is => 6% I want it to be "Red" If the difference is From 1% to 5% I want to be "Yellow" And…
-
Duplicate Entry Formula for Data Across Multiple Columns
Hi, I'm hoping someone can share the correct formula to indicate a Duplicate entry where all multiple columns all have to be 'true' for the indicator to show a duplicate row/entry. Example: To trigger the "DUPLICATE ENTRY' status, I want to make sure SITE, BLDG, ROOM, and DESCRIPTION/CATEGORY all have the same value, not…
-
Update on Formula Errors with Range References
We're investigating reports from a small number of customers who are reporting issues with cells containing a formula with a range reference. The issue is that the cell value flips between the correct calculated value and some formula error, such as #BLOCKED, #REF, etc. This behavior occurs when a Smartsheet internal…
-
#blocked Formula
I have a sheet that used to be operationnal, and sudenly, I get "#BLOCKED" on some of my formula. I know that the formula should be ok because I have the exact same formula in similar pages. In fact, the formula is a nice addition to the GANTT view. It list all the predecessor task by taskname. I have another one for all…
