-
Dropdown List Alternative with Automatic List Update and Dynamic List Features
There have been many requests for improvements to the Dropdown list from Smartsheet Community. The two most typical requests are Automatic updating of the list @Justin Mauzy @Taylor Compton - NOAA Federal Dynamically changing the list of the following selections based on previous selections @Ian Cooper @Mehran Bagherian…
-
Dynamic Dropdown List
Has anyone created a workaround or built a solution that provides dynamic dropdown lists?
-
Automatically add Child Sum to Rows
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…
-
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…
-
Need a cell value on each row
I need a way to either do a checkbox or a value for each row in my sheet if a cell has a value. I can't use = [Column name}$6 because the column formula does not support this. Does anyone know a work around for this?