Sheets
Discussion List
- How can I use MATCH to find if an instance occurs within a group of values joined with JOIN? For example, if I join the values in three columns (Red Yellow Blue), no commas just a space, and I want to…
- Can smartsheet auto-populate cells based on the above cells in a column like excel do? When completing text cells the system doesn't indicate that text word is already above? This is useful not to dup…
- Each time a row is added (which is requiring an approval) i need the sheet to export the new data, to either an excel spreadsheet or google doc and upload to a secure site. The other option would be t…
- Hi, I'm trying to schedule 2 dates form the same line into a calendar. For example. Each time we sell a job, the job has a Part A installation, and a Part B installation. With this the line would have…
- Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team …
- Good Morning, Is there a way that if I @someone on my smartsheet and it sends them an email that I can be notified when they click the link and look at the smartsheet?
- I'm trying to decide between Smartsheet and Excel for forecasting about 300 accounts over the course of a year with monthly analysis of forecast vs actuals. I'm doing some prototyping and pros and con…
- I am using the following formula (gained from a previous community entry, thanks guys) =IFERROR(NETDAYS([Construction quote date]@row, TODAY()), 0) it is calculating the number days between a quote da…
- Is it possible to link a drop down list to a query from another sheet column. For example It would be great to be able to have users select items from a list of the top ten sold items. This list would…
- Hello, I'm trying to find a way to automate my Reports. I want to create a Report that uses an entire folder under Data. So that when I add a new sheet to that Folder the Report automatically updates …