-
Capturing multiple statuses, reminders for recurring tasks, form
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…
-
Set a conditional formatting across the entire sheet that only affects the cell where the condition
I'm trying to find a way to do what I've done with spreadsheets before, but I am not seeing a way to do in Smartsheets. In some of my fields, there are instances where I won't have a value. I populate those with NA, and I'd like to turn the fill for those boxes gray automatically. Traditionally I'd do a conditional format…
-
Informational Headers
Hello, Can somebody tell me if it is possible to include an informational header at the top of the sheet. In my case, this could contain the project name, team members/contacts, scope and some basic data. It could even be a text box that sits on top of the cells. I would then start my tasks beneath it. The inability of…
-
Can a formula determine hierarchy?
I doubt this is possible but thought I'd ask anyway. I want to know if there's a way to indent a row with a formula. So if a user submits a form and indicates that it should be a child row of a specified parent row, would it be possible to have a formula in place that indents that row when certain conditions are met?…
-
Keyboard shortcut request, hyperlinks and open discussion
I've had some trouble getting hyperlinks to import/export, and I have alot of rows that I have to perform manual operations on in bulk. i also have some nifty tricks with AutoHotKey as long as operations can be completed using keystrokes. Can we please add keyboard shortcuts for adding hyperlinks and opening the discussion
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
Next deliverable date
I have a list of deliverable dates and I would like to make the next deliverable date turn red, all dates after that remain white and any dates that occur in the past green. I figured out how to get all past dates green but I can't figure out how to turn only the next date in the future to turn red without turning all the…
-
Merge Add-on for Google: Formatting Options?
I'm using the Merge Add-on to generate email messages and PDF documents from my Smartsheet. While my sheet has many columns of dates in the MM/DD/YY format (which is good for managing the data), I'd like my documents to be in the 'monthname dd, yyyy' format. Are there formatting codes for the merge fields, or is there…
-
Help needed with formulas - paid work opportunity!
Hi everyone, My colleague and I are new to SmartSheet and we are having some issues with a few formulas and we can't quite work out what has happened. We are offering paid work at an hourly rate for someone to join our team to help troubleshoot and fix our SmartSheets issues. If you're interested, please let me know!…