Sign in to join the conversation:
I would like to be able to send a snip of smartsheet items (including dashboards) in a similar manner to an alert on a regular basis or on an action from a user.
As an API user I would like to be able to move reports to different folder/workspace as we do with sheets, so I can perform mass changes.
What is the current status of including a date time format/function and the ability to have multiple calendars per sheet? The lack of these 2 functions has limited the use of Smartsheet for several projects and outages at our facilities.
As a basic outline, I have column 1, 2, and 3. Columns 1 and 2 list 4 identical options: A, B, C, D in a drop down menu. Essentially, I would like column 3 to calculate/display the difference between columns 1 and 2, removing a duplicate. For example: Column 1: A, B, C, and D are selected in the drop down Column 2: B is…
I need the formula to get the text from the next row in a specified column. I am creating the formula in row 2 in a column named 'Next' and want it to bring back the data from column 'Test' in row 3. This is what I have tried so far but getting #unparseable error. =INDEX(Test:Test, row() , +1) =INDEX([Test]:[Test], row() ,…
I have a formula that is currently working (see below); I need to add a condition, from a specific Column (Study Status)-that if it equals a particular choice ("Study Ongoing - Follow up"), that it doesn't even bother looking at this formula and automatically turns the FLAG off. Furthermore, I'll need to have several…
