-
Copying Alerts & Actions from sheet to sheet
Hi all, I have a set of 5 "Alerts & Actions" that I need to set up on 32 different sheets. Is there a way of "copy and paste" those rules, instead of manually set them up on each sheet? Thank you.
-
Help on formula: countifs with multiple criteria
Hi everyone, I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image). The 2 sections are called Food and Non-Food. The active stages are called Planning, Strategy Decision, Tender, Evaluation and Contract. Other terms applied in this…
-
All technicians preferred old Grid view...
Since smart sheet update new version. We are used to able to look details with Grid view.. Now we have to review with grid view and then go to list view and able to see detail...it makes more longer time operate n more comfusion..please we prefer before version smart sheet
-
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…
