-
# BLOCKED
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])" All that is doing is counting all…
-
If Index Match
Hi, I'm trying to figure out the due date for a submission if the dates remaining is >0 below is the formula I came up with, however it is not working. =IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remaining}, @cell > 0) Also, is there a way to do an Index Match or vlook up that gives me the…
-
Can Pivot Sheets shared or embeded in iFrame?
Just try the Pivot Sheet in the smart sheet, that is the something I am looking for. But whether it can be shared or embed in wiki. Which I don't need to export the result and do the analysis in the excel?
-
Automation Workflow - Error Check
Hello! I am setting up an approval workflow and have run into some questions. Example: Trigger: If "Status" is set to "Sent for Approval" Action: Send approval to "Final Approver" Now, it's a very simple workflow, but, if my "Final Approver" is not populated, or there is a typo, etc. Is there a way for it to…
-
Dashboard - Gantt Show Only Today Forward
Anyone know how to make dashboard widget of a gantt chart only show today and forward? It displays correctly in the Report Builder as there is an option in Settings > Timeline Display to check the box "Open to today's date". Can't figure out why it won't do this in Dashboard widget. You can scroll to today and it prints…
-
Permission changes - Create & manage manual alerts for other people
Alerts, reminders, and requests * Create and manage manual reminders for other people * Create and manage manual update requests * Create and manage automated alerts and reminders Does this mean that any time someone wants to be alerted about a change, etc, that only a licensed user can create them? Our Company has…
-
Open To Today's Date for Viewer and Editors
The "Open To Today's Date" feature works for the sheet owner/admin, but if the user just has "editing" or "viewing" rights, they are forced to scroll on the x-axis to get to today's date. Is there a way to make the feature also work for all users?
-
Help with Formula!
Hello, I'm pretty new to smartsheet but slowly working out how to create some functioning formulas! I wonder if anybody might be able to help me with the latest one please? I have multiple columns containing different data types (some are tick boxes, others are dates and some will say 'N/A' - I am trying to write a formula…
-
Prioritize/sort rows (possible feature request)
It is possible to drag 'n drop rows to change their order, but if you order by some column this "index order" is lost. I need some way to prioritize rows, with the most important at the top. I can do this by adding a column of type number, and manually enter the index for each row, but this is rather cumbersome. What I…
-
Automatic Jira to Smartsheet ONLY
I'm trying to setup an automatic, one directional Jira to Smartsheet sync. The options are either bi-directional automatic, or manual one direction. The manual only updates if I click through multiple screens to find the workflow "Run" button. The Automatic scares me because I don't want Jira getting corrupted since lots…