-
'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
-
Pull account name from another sheet???
Hello, I need help with the following. I am buildig a sales pipeline tracker. On one sheet I have a list of master accounts. On the tracker sheet I have a column named account list. Can I do a lookup/dropdown to get the account names from the other sheet? I want to ensure the account names are typed correctly by doing a…
-
Start Date Autofilled by End Date and Duration
I'm building a construction schedule for cabinetry across multiple projects my company has going. Is there a way to dictate a start date, date the vendor needs to start working, by the known building/finishing time and the end date, date they need to be on site. I.E. I'd like to put in the end date: 1/22/18 and a duration…
-
How to Concatenate multiple cells into a single cell within a VLOOKUP formula?
I've created a VLOOKUP formula to pull in data from a source smartsheet, into a 'staging' smartsheet but, if more than one row match the criteria, only the first row entered in the source smartsheet get entered into the cell on the 'staging' smartsheet. For instance, I'm looking for entries on the source smartsheet that…