-
Nested IF AND with Multiple logics - Not bringing the expected outcome
I am trying to write the following logic to calculate the SLA breach. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL - Greater than - 1 day. However, the formula is not accurately bringing the breach/no breach as expected. Except "Critical" all of the other severity logics…
-
Recurring Tasks
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
-
SmartSheet Jira Connector
Hi Team, We are trying to integrate SmartSheet into Jira, however when looking at "Jira Connector by Smartsheet" I see the following: https://marketplace.atlassian.com/apps/1215530/jira-connector-by-smartsheet/version-history We are running Jira Cloud. "version":"1001.0.0-SNAPSHOT", "versionNumbers":[1001,0,0],…
-
Bridge - Copy all attachment names to another sheet & get data from an array with a Child Workflow
This solution copies all attachment names from a source row and adds one row for each attachment name onto a target sheet. Each target row contains one attachment name and the source row primary key. The solution uses a Child Workflow to get individual data values from an array in the Parent Workflow. The solution is very…
-
Remove Me function from workspace who shared with a group
Hi there, is there a way to use remove me, in case a workspace or sheet where shared with a group an i am in this group? ...i haven't found it so maybe you know thanks!
-
Allow editing for cells in a formula column
Hello, I have found that when a column is a formula column, you can no longer manually update those cells--ever. Is there a reason these cells need to be "locked down"? When you add a formula, just to the cells manually, and not the entire column, you can always update it whenever you need to. I know I can "turn off" the…
-
Auto Numbering
Hello fairly new to smartsheets and mostly stumbling around. I wanted to create a ticketing system for new IT admin request. I created a form. And then on the sheet that is populated from the form I created a column for "Ticket Number." I wanted to create an automation so that whenever a new row is added to the sheet…
-
Auto number risk column only adding till row 20 to another sheet reference
Dear reader, I came across a unique issue and need a help. I created a 'portfolio sheet' with list of projects in one column and a next column for Risk ID with text single line I created a separate sheet 'Risk register' with a dropdown of all the projects similar to the portfolio list and added a Risk ID column with #Auto…
-
Dashboard Shortcut Widget Ability to Open New Tab
When you use a Dashboard Shortcut Widget, the link goes directly and you lose the current page. I would be great to have an option when adding a link to have it open in a new tab/window. A lot of our folks refer to the old page and the new one.
-
COUNTIFS with an AND
I am trying to use a COUNTIFS formula with an AND. I need to account for two different conditions to determine the count of another column. COUNTIFS the Master - Project Status column is not "complete" AND Master - Sales Stage is "Won" should return a count based on Master - Service from a row. =COUNTIFS({Master - Project…