-
Cell Highlights Automatically
I'm using the Event Planning with Budget template. Whenever I add a new row, then type in text in that row, it automatically highlights specific cells in that row a grey color. Even though the row above and the row below are highlighted in white and initially the new row is white. How do I stop this from happening? It's…
-
Is it possible to Auto-Fill dates?
Hello, I'm sorry if this question has been asked before, but I couldn't find anything through the search function... I have prepared a template for event management. We use the same structure for every one of these specific events that we do (the event date is announced, and then we work back from the date to establish…
-
What is the "Created by" option supposed to do?
I have used this option for a System column thinking it would automatically populate the email or user name of the person (within my network) who submits a request by web form. However, all tests by several users of this functionality show the same "email address" - web-form@smartsheet.com when the request hits my…
-
Logo's
How can I save a logo per sheet?
-
Recurring Reminders
Is there any way to set recurring monthly reminders for each row for content which doesn't get updated? I am doing up a rental collection sheet, and need to set reminder for the person in charge on a monthly basis. Thank you.
-
Column Properties
Hi Community! Is it possible to only allow for a single type of text in column cells and not any other type? For example, if I choose the column property as a date, can the cell restirct the text in the cell to only allow for dates? This is done in Excel using data validation. Please help! Thanks, Dave
-
Trying to build a good, dynamic task list
I'm working on getting a good personal task list system going within Smartsheet. I've gone through a small number of efforts to get what I need, but I still have a problem around getting something dynamic and quick functioning. 1. Built a task list based on the task list template. With no automatic sorting, I have to sort…
-
If N/A checkbox is marked note % complete as 100%?
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Thank you!
-
Week Numbers
How do I display a week number in a field, that references of a date field.
-
Automatically add tasks to a web form populated row
Hi, I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form? I review sets of data that are submitted by multiple business unit and partner companies. The form this takes in always the same, and we have a set…
