-
Automatic item numbering
It would be really good to be able to format text entries so that they are numbered automatically based on indentation level like: 1. Header 2. Header 2.1. sub header 2.2. sub header 2.2.1 sub sub header 3. header I actually wonder how it can be it is not implemented already? It is quite important to be able to reference…
-
Re: Task Alerts
I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then included the following columns in my sheet so; * a date column for when activity is due…
-
Proofing Full Screen
When you initially send out a proof in Smartsheet you get a button to "Review Proof" which sends you to a full screen mode to review the image. However, whenever you got back to review that proof for that row it only opens it up within the sheet, in a much smaller window. Does anyone know if there is a way to go back to…
-
Export into Excel and PDF not capturing all of the data
Hi, this is my first time posting. Hopefully this is not a duplicate of another posting. I just ran into a problem this morning with "What you see is what you get" is not consistent in exporting a document. I have a roll-up document of various sheets and I go in everyday and export a report. Today content is going missing.…
-
Is there a way to automatically add an entry on a monthly basis?
Hi, all. I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this? Thanks!
-
% Complete Column Only Works for Some Parent Tasks
I created a basic project sheet and have been filling in tasks for two main deliverables (both shown as parent rows). Under those two parent rows are several child rows. However, the % Complete column is only auto-calculating for one of those two parent rows. The other remains at 0% no matter what I put in the various…
-
Team Calendar on MS Teams
Hi. My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view? Thanks, Martha
-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
-
Nested If with Multiple Conditions Automation for Project Management
Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started") I just…
