-
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?
-
Document Checklist(s)
Hi all I am looking for the best way to create a document tracking checklist that tracks all necessary documents in our loan origination process for EACH applicant that may be on the loan. There could be 1 applicant or there could be 5. We could have individuals or entitys on the loans as well. I need to be able to pull…
-
Setting milestone to Finish date?
Is there any way possible to set the milestone marker to the Finish date in a sheet? Right now, I'm still having to manually set the Duration column to "0" to get the milestone icon, but even when I do that, the date of the milestone gets set to the Start date.
