i have multiple columns in a sheet for various tasks that need to be completed (water, electric, etc.). the columns are a dropdown to pick from complete, in progress, not started. i wanted to insert a column next to each task that would insert the current date & time when the status was changed to complete. i attached a…
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
Has anyone experienced the check boxes randomly changing to date field (properties of column changing)?
Hi, I have a report that shows 3 business units from last month. I would like to add bonus to the unit that achieved best results. Is it possible to make max() function based on fields in the report?
Hi, If something happens to my file like Grid, is it possible to go back to previous version of it like in Office365?
I created a timeline and when I chose Gantt view only two bars on the Gant chart are showing even though I have probably 25 tasks. I have a beginning and end date for all tasks. How do I get the items to show on the Gantt view? Screenshot attached. Many thanks for any help.
I'm using this vlookup formula to pull back a value from a data sheet. Let's say the value of NUMBER81 is 123456 and when I type in the formula on the desire sheet it returns "No match". When I go to the ACCOUNTS sheet and look at the data there is a value equal to 123456 in Range 1. When I put an apostrophe in front of…
I have a sheet that goes from 213 to 215... ideas?
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK
Hello, I am looking at finding a way to send a quote request to a chosen list of suppliers. Is there any way I can send a row with all of the quote information to multiple email addresses where it will create a new row for each quote returned? I can then review the prices before choosing which supplier to proceed with. Any…