-
Update cells via form or secondary sheet?
I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I need updated? If that isn't possible... Is there a way to make an automatically…
-
Is it possible to use a formula to help users complete a form?
We are asking for updates to quality documents. The form asks for the document number and the title. Is there way to auto-populate the title in the Form once the number is entered?
-
How can I print my full chart from my dashboard.
HELP!! I am having issues attempting to print several charts from my dashboard. They are fairly large charts and I would be fine if they were on multiple pages. However, when I attempt to print them, I am only getting portions of the charts. And the very first chart is for some reason adding a huge space between the top of…
-
Conditional Linking?
Hello, I was wondering if there was a way to unLink cells if a condition is met, i.e. if Column1 is checked then UnLink all cells in all rows this would be to lock values coming in once checked or if that is NOT possible ... If a value that comes into a linked cell (from another sheet source) is say $10 and I set up an…
-
View our recent webinar on collaboration and best practices!
Drive collaboration and transparency across your teams and organization, allowing everyone to work together to achieve more. View our recent Collaboration Best Practices Webinar where we shared how Smartsheet streamlines collaboration through: Sharing sheets and workspaces Intaking requests with forms Automating updates…
-
"Live Date" is 4 weeks from "Submitted Date"
Hi, I'd like to set up conditional formatting to let me know if the "Live Date" column on my grid is indeed 4 weeks from the "Submitted Date" (Submitted is an auto-populated cell if that matters.) I know I need a helper column, and I know how to do greater than, less than, equal to with an =IF statement, but how do I set…
-
Forms - Workflow to track submission
Hi, Is it possible to populate an existing row using forms? The idea is we have two existing columns (Customer and Due date)and the rest are from the form. If no reply has been made past the due date, a workflow would automatically send an email to the recipient reminding to complete the form. The problem is, form…
-
Finding duplicates and checcking blank cells
Hi there, I am at my wits end and I think it is a very easy solution, however I cant see it. I have a column of project numbers, and I am trying to see if there are any duplicates, as well as if the project number cell is black, to leave it blank. What I have done is sort the project number column in ascending order and in…
-
Publish to Personal Google Calendar (not Enterprise)
Hello, thanks in advance for your help. I have two Google Calendars, one for work and one for personal. My Smartsheet account is owned by my work Google profile. I have one sheet for work/life task management that is shared with my personal Google profile. I would like to to publish this one sheet to my personal Google…
-
How to indicate that a cell will be automatically calculated?
Ultimately, I want to indicate to users when a cell will be automatically calculated, so they don't overwrite the formula. I've figured it out in one case, but not in another. Both are shown below. So, more specifically, any ideas on how to detect a blank cell when using =MAX(DESCENDANTS()) in a Date column? I have a…