-
Touch Sheet to update formulas with Vlookup
can a Vlookup (or other cross sheet reference) be used to touch a sheet to update today() formulas in unopened sheets? if we can exploit this cross sheet functionality I might be able to create a master sheet that I can open and refresh all of my sheets daily without having to open each one of them. This would allow me to…
-
Number of Days Ticket is Open
Hello all. I am a newbiw to Smartsheet, and I'm having trouble correctly adding a formula to one of my sheets. I have a repair sheet with a column that shows the date the ticket was created and a column that is labled number of days open. How can I have this column automatically display the number of days the ticket is…
-
Undo question
Hello, I was editing a formula and somehow the whole sheet appeared with the error #INVALID OPERATION. I was trying to undo the last change to reverse it, but the button wouldn't appear enable and the sheet was saved! I invested a lot of time ==(. Is there anyway to recover the previous version of my sheet? Thank you.
-
Successor Column
Hello, Could the SmartSheet community get an update on the successor column from the products team? I believe this was first requested a few years ago in late 2015 and has been by others multiple times since then. Thanks, Riley
-
Smartsheet Asian Server
Hi Smartsheet team, Is it possible for you guys to provide server in asia? Smartsheet takes longer to load here in the Philippines. Thanks, Dennis
-
Charts
Hi Guys, Literally just started on Smartsheets, I have created a RAID Log template and was hoping to create a dashboard that would complement my log. Unfortunately every time I try to fill in the data the system tells me my data is invalid. Could you help me how to make this DATA fit in some sort of chart. I know this is…
-
Index(Collect add to formula page
Can we get an index(collect example added to the collect formula page? I have found it extremely useful in finding specific iterations of data, and I only stumbled upon it trying random things to solve a specific issue I had a while back. It could have saved me quite a bit of time if I had seen an example of it when…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Stock sheet automatic email when stock drops below an amount....
Hi everyone, We're putting together a stock sheet and we want to create notifications so that when a figure in a cell drops below a certain amount an email is automatically sent to the relevant people so they know to re-order. Can anyone help please? Many thanks!
-
File Upload from Customer into their Designated Row
I was hoping somebody could help. I have a form set up where customers can upload their artwork directly to our sheet and once checked I send an approval request as a proof. However if the proof is declined or we check the file and it isn't print ready we require customers to upload a new file (artwork). I have tried this…