-
Copying Date to Text Cell
Hi everyone, Is there any way for a formula or automation workflow to automatically copy/insert a date into a text cell? I'm trying to create a formula where if the STATUS column is "DATE" it will then Copy the date the item was created into a text Column. Is this possible? Thanks!
-
Referencing a flag column in a Function
Hi everyone, I'm currently in the process of adding functions to my task list. I have two columns that I am trying to edit the functions of. One, (Needs Following Up) has a "priority" symbol to mark if the parent row has a child that is a follow up item. The other (Follow Up Item) marks if a row contains "follow up" in…
-
#DIVIDE BY ZERO
Hi, I have a Smartsheet with calculated columns like - =SUM(Open@row / SUM(Open@row:[Past Due]@row)) The Smartsheet is being used to create Donut graphs on a Project Dashboard. In the example above; Open = 0 In Progress = 0 Closed = 0 Past Due = 0 rather tan getting 0%for Open, I get #DIVIDE BY ZERO How do I resolve this?…
-
How to find (max less one) from a list of entries
To assess whether a team is progressing, my user needs to show the most recent score AND the score just before that one. The difference between the two will show direction of development. Finding the score associated with max([date of score]@row) is reasonably straightforward. Any ideas about how to find the score for the…
-
Formula with Dates
I am trying to reference another sheet where that column will be marked "completed" and then using the star symbol, have it toggled on if the date is in the month of January. Any help is appreciated! I'm new at this :) =IF({RANGE 1}, "Completed", IF(AND({RANGE 2}, <=DATE(2022, 1, 31), {RANGE 2}, >=DATE(2022, 1, 1), 1, 0)))
-
Automatic Data Dragging
Hi Community, I am looking for a formula that can help me to pull data from one smartsheet to another. First thing that came in my mind was the VLOOKUP, but in this case it is not sufficient. The formula should pull the all the rows (complete row) from another smartsheet, but only if the budget impact (multiple columns) is…
-
Formula to count In Progress
Hi, can anyone help with this formula? I need to count the children in a smart sheet project and not include the parent or grandparent as they have formulas that alter based on the overall % of the project as a whole. I have helper columns that indicate level, and I need this to ignore the summary count from 1,2,3 etc...…
-
Formula to return 'TBA' if cell contains text 'TBA'
Hi, I'm currently using this formula which works: =IF([\[H\] Variance (%)]@row < 0, "Under Budget", IF([\[H\] Variance (%)]@row = 0, "On Budget", IF(AND([\[H\] Variance (%)]@row > 0, [\[H\] Variance (%)]@row < 0.15), "Moderate Budget Overrun", IF([\[H\] Variance (%)]@row > 0.15, "Significant Budget Overrun")))) However, I…
-
Symbol Formula using date and another field
I need to create a formula based on the following criteria: 1) Contract Type is...Lease....then the following needs to be assessed in the Target Completion Date column. 2) Target Completion Date is more than 70 days out "Green" 3) Target Completion Date is 20 days out or less "Yellow" 4) Target Completion Date is in the…
-
How does Collect function apply in this case?
For the sake of data integrity in a big sheet that has a column for a cost name and its amount, I need the same values to be populated for the same cost name. for instance: if one column has items names and the second has values: Item1 20 Item2 30 Item3 40 Item 1 (I need to have here 20 in this cell) Item3 (I need to have…