-
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.
-
Highlighting a single word in a different color in a cell
Is there a way to highlight a single word (or words) in a differenet color in a cell? Thanks!
-
Conditional Formatting when changes are made
How do you highlight when a change is made to any row or column? e.g. if someone changes the due date, I want the entire row to be a color.
-
Time in 24 hours
Please help! I am working on a IT Change Request sheet where the request is submitted by Forms. For a change to take place we require a specific time to be entered. I know Smartsheet currently does not have a time option, but is it possible to have the Implementation Time, whether it's entered as AM or PM or in a 24 hour…
-
Conditional formatting saving error
Im getting the attached error when i try to save conditional formatting