-
TODAY Formula Constantly Changing Date to Current Date
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
-
Formula with date column weirdness
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
-
This formula is working for other number ranges but not this one
Hello, Trying to do a count and this formula is working for all other number ranges, except for this one. Any ideas? Formula is this: =COUNTIFS([Risk Issue Factor Priority]:[Risk Issue Factor Priority], ">0", [Risk Issue Factor Priority]:[Risk Issue Factor Priority], "<7", Status:Status, "<>Complete", Status:Status,…
-
Best Practices for overall schedule deviation
I'm trying to find the best way to show the overall difference between the date the case was Started and Finished. ideally it would organize all opened and closed cases showing an overall schedule/performance
-
Can I Reference Another Sheet in Table View?
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.
-
Operations Intake, portfolio & capacity management
I’m a fairly experienced SS user looking for advice or automation tips that have really transformed your workflow. We currently have an intake form submitted by our field team, which populates our master tracker. After submission, managers review these entries and assign them to team members. What are the best practices or…
-
Formula to extract and sum cells from drop down
I am working on putting performance evaluations into Smartsheet. We have a set of criteria that employees will be rated on, and below is our scoring scale. Scoring Scale 5 - Exceptional: Consistently exceeds expectations; demonstrates leadership or innovation in this area. 4 - Strong: Frequently exceeds expectations;…
-
Need a column formula that pulls from the parent row
Is there any way I can create a column formula that pulls from a parent row? "For need formula here" I need to divide the value and cost from the parent row then multiply the value in the child row. I will be having multiple parent rows so I was hoping to have a column formula
-
Why does my stacked bar show 120%?
-
Return Value from List
I have a sheet with a list of non-distinct master ID numbers that are grouped into "Group 1" through "Group 6" based on a distinct secondary ID. I am trying to write a formula to grab the greatest priority value if there are differences within the same master ID. My formula is in the correct priority order. Here is what I…