-
SmartSheet Jira Integration
Hi all, I'm new to smartsheet and have also purchased their Jira integration. I'm curious as to how many others here are using this integtation? There's a lot of quirks with the integrations so wanted to see what others thought of it and how they're using it. Cheers, Imran
-
How to right-size a Project Portfolio?
This question may be more on Project Management and Culture than it is solutioning in Smartsheet Software, but possibly some of you have done something creative in Smartsheet to help your organization. I have been with my organization for a year now and have been able to build out a project portfolio. Having the visibility…
-
# 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…
