-
Cancel Scheduled Backup
Does anybody know how to cancel scheduled backups?
-
Formula to determine the date that another cell was updated
Hello, Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date. =IF([Status]1 = "Completed", TODAY()) Thanks for your help! Andrea
-
Automatic Cell Highlighting
I am logging man hours for construction jobs. I have three columns that perform this function. One column for "Budgeted Hours", one for "Actual Hours" and one for "Remaining Hours". I input hours into the "Actual Hours" column daily and it updates the "Remaining Hours" column automatically. I want to set up a formula that…
-
Sum of work log between a date range for given list of users
Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all users. I tried summits but not able to come up with anything as it is always giving mw wither 0 or invalid argument. I tried…
-
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,…
-
Calculating a percent
Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized. Any suggestions are appreciated. Thank so much, Katye
-
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…
-
Contact Columns marked Multiple Don't Populate Legacy Reports
I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I noticed that Reports count those columns as different than other Assigned To columns without this feature enabled even though…
-
Two Columns Named 'Assigned To'
Hello. I have a report that pulls milestones from multiple project plans. I created this report from a template within Smartsheet. There are two columns named 'Assigned To' Can you provide any answers as to why they seem to be duplicated and pulling information differently? Note that I have multiple shared project plans as…
-
Sending as attachment with filters
It would be awesome to be able to send out recurring attachments in which the pdf attachment is based on a filter. For instance, if it was a construction schedule and I wanted to send out a recurring two-week outlook then I could send it based on my two-week outlook filter.
