-
Auto/number - date on particular cell, not whole row
I'm trying to find a way how to populate a datestamp in a cell based on the last change from an another cell in a particular column fe: Row 1 - column A: dropdown (Start, pending, stop) Row 1 - Column B: I want the date when Status changed on column A Auto/number - date: works, but it looks at every cell on that row, i…
-
Conditional Formatting if Calculated
Greetings, yes, here's another post about conditional formatting. I swear that I have searched and cannot find the answer to this, so... I have some date fields that I've calculated based on another (30 days after X date). I'd like to automatically format these calculated cells so I can instantly see which ones are…
-
Is the Parent Row expanded?
Is there a way to know if a parent row is expanded (that is the + sign was clicked and the children are visible)? For example, my sheet contains 3 rows that are parents (Orders 1, 2, and 3 below) each representing a different order. The children of each parent is an item in that order. For sake of discussion and…
-
If column A status is X then tally column B
How do I do this? If my column A status (dropdown) is Pay Supplier I want it to then tally the column "amount due" with that status. Thanks
-
Criteria need for a "is one of" filter
When making a filter using the condition "is one of", how do you separate the options in the criteria? I have tried commas, semicolons, quotation marks and parentheses. None are working.
-
Remove conditional formatting from parent row
Is there a way to remove the conditional format from the parent row? I want the parent row color to stay a specific color, regardless of the dates, etc. See sample, I want the blue to cover the full row.
-
Drag Down Predecessor Formula to change with rows?
Hello, So I have created predecessor formulas but when I drag them down or copy and paste them to another set of rows down below they still refer to the first rows while I want them to refer to the new rows but in the same order. For example, If on row 6 I have the formula 5FF+6D, I want to be able to copy and paste it to…
-
Dynamic Status
A more refined and slightly more universal solution to the first posting is as follows: =IF([% Complete]18 = 0, "NOT STARTED", IF(AND([% Complete]18 > 0, [% Complete]18 < 1), " IN PROGRESS", IF([% Complete]18 = 1, "COMPLETE", IF([% Complete]18 > 1, "INVALID ENTRY", IF([% Complete]18 < 0, "INVALID ENTRY"))))) This assumes…
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
'Find & Replace' functionality in SmartSheet?
Is there a way to use a 'find and replace' functionality across the entire estate of worksheets through utilising Dynamic View coupled with Reports?
