-
auto date entry multiple columns
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…
-
Custom Column View Templates
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.
-
Checkbox Issue
Has anyone experienced the check boxes randomly changing to date field (properties of column changing)?
-
How to refer to Report fields using Grid function.
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?
-
Cell history
Hi, If something happens to my file like Grid, is it possible to go back to previous version of it like in Office365?
-
Help with Gantt chart -- only two bars showing
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.
-
VLOOKUP data type question
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…
-
My Smartsheet is showing a row number skipped
I have a sheet that goes from 213 to 215... ideas?
-
Report assigning random background color
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
-
Quote Request to Multiple Suppliers
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…