-
Find a Match withing a Join?
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 MATCH the value in a cell (say, "Red"), how can I see if the joined values (Red Yellow Blue) contains Red? Right now, the…
-
Can smartsheet auto-populate cells based on the above cells in a column like excel does?
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 duplicate like currently, excel can do it by default. Any idea if this is possible or can be enabled would be appreciated.
-
Automated export and Automatic upload
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 to do this based on frequency like nightly, but I guess the real question for me, and yes I am both new and green here, can…
-
Multiple Installation Dates to show on Calendar
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 Part A Date, Duration and a installer. Same with Part B. The Installer is conditional formatted as a colour to show up in…
-
Scheduled export of sheets
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 subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…
-
Read receipt
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?
-
Forecasting
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 cons for both systems but haven't yet decided what to do. Has anyone used Smartsheet for forecasting? Have you liked it? Have…
-
using netdays to detemine number days from quote day to closed
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 date column and today's date. however I want to fix the number of days when the actual close date is entered into a cell…
-
Dynamic drop down list
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 update as sale demand changes. or being able to only select items of a certain type based off another column.
-
Automation, Reports and Projects
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 and I don't have to modify the Report after every new sheet. Another automation I would like to do is create a site…