-
Invalid recipients in Alerts and Actions rule
We have lots of alerts/actions/notification rules setup across lots of sheets. When I delete a user due to employee termination, then I get this message: "Invalid recipients in Alerts and Actions rule" I don't want to have to dig through dozens of sheets to remove the people, how can I do this on a mass scale?
-
Zapier sends string, but Smartsheet processes as an integer
We use a unique number sequence by combining two integers for each row sent to Smartsheet. I worked with Zapier to verify that the integers are sent to Smartsheet as a string, not a number. What I am seeing is if the string is not long enough, Smartsheet converts the information to a number and our formulas do not…
-
Maintaining Formulas When Sorting a Sheet
Hi, Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was moved to. My formula is a COUNTIFS and I want it to count what I am asking regardless of where in the sheet the row where…
-
Automatically marking something as complete when requirements are filled
Hello, I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed, In-progress and Not started.…
-
A-Z Rows
hi ive set up a couple of new sheets and looked to sort the rows A-Z but wont allow me? any ideas to fix this problem ta
-
Indent/Outdent
With the new format of the tool bar (now a ribbon at the top), I can't for the life of me find a button to indent/outdent to create tasks and subtasks. Can anyone point me in the right direction? This is a trial version... am I missing some of the key functionality?
-
validating cell value
Hi, I have a sheet with diferent columns, one is "Initial Date" and other one is "Ending date". How can avoid users update "Ending Date" with a date earlier than today?
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Linking to a Smartsheet functions
I've seen posts that contain links that create an action, such as "click here and a copy of that sheet will appear in your instance of Smartsheet" I cant find the OP, and cant recall if she was staff perhaps, but the link worked. Is it possible then for me to create links to actions, for instance a link from that would…
-
CORS in Ionic and third party api(Smartsheet)
I am trying to get data from smartsheet API. When I use postman and nodejs in separate server code, it works. But if I use the API inside the Ionic with HttpClient (@angular/http) it gives CORS issue with run in browser. Failed to load https://api.smartsheet.com/2.0/sheets/1235941564208899972: Response to preflight request…