-
Upload Json file data into smartsheet
I need some help in passing json file into smartsheet. I want to pass all the values from file and load exactly same values or some columns as per my need in smartsheet. I am using below syntax in the body to populate some columns as per my need {"cells":[ {"columnId":8423944366647172,"value":false},…
-
Adding multiple columns at once
Hello, Based on a previous post I saw in regards to rows, I wouldn't be surprised if multiple columns cannot be added unless done one at a time, however if it is possible can someone please assist? I would like to add about 5 columns at the same time without having to add them individual and name each one at a time. Thank…
-
how to hide columns for certain users
How do i hide certain columns from users.
-
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
-
COUNTIFS with ranges
Hi, I have a task list with a flag column and collaborators in 5 columns, so a collaborator could be the primary responsible or up to a 5th level involved in a task. I haven't been able to use Countifs function in a formula which will retrieve from the list how many tasks a given worker is involved into, the function works…
-
Overdue Calculation with Conditions
Hello, I have a "Due Date" column and a "Complete" column. I want to create an overdue days column. If 1) the complete column has not been checked, and 2) today's date is past the due date, then I want the overdue days column to calculate the number of days (net days and not work days) past the due date. I've looked at…
-
Webform Email Notifications
We are using smartsheet to Nationally track data. When a webform is submitted there is a requirement to email a certain person within the company notifying them that a report has been issued and action is required. The list of different people who might have to be emailed on the report generated is very long and not all of…
-
Smartsheets Approval Request
Hi all, I am setting up an approval request in smartsheets and needed some insight. Essentially, I was wondering if during approval step that you can download an attachment instead of it opening in a browser. I've attached a screenshot to hope clarify
-
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?
-
Report Builder - What section
Hi, I'm trying to number actions on my list as 1.1, 1.2 etc, all relating to a section 1 in my smartsheet. I also have a handful of actions that I need to number as 1.6a and 1.6b etc. When creating the Report Builder however, the 'What' section doesn't seem to handle the letter, only the number, therefore any rows that…
