-
Merged: Not able to access Smartsheet API Doc getting error
This discussion has been merged.
-
How to make my due date column continuous and with a specific time range in between dates
I am trying to make the due date column so that it enters a date for every 22 days. I want this to be an "endless" column in that it goes all the way down without having to be manually entered. Is there a way to set the due date column to calculate this automatically and fill out all of the rows under it?
-
Put a pause on calculating SLA
Hello, I manage a RAID log for my team. I want to calculate SLA for each issue. I don't want to calculate if the case is checked in IT column and if it's status is "Cancelled", here is my current formula: =IF(AND(Status@row = "Cancelled", IT@row = 1), 0, IF([Closed Date]@row > TODAY(), NETWORKDAYS([Created on]@row,…
-
Excel Conditional Statement formula alternative for Smartsheet
I'm trying to replicate a nested Excel formula in Smartsheet, ensuring it applies the below criteria accurately. However, when I use the Excel formula in Smartsheet, it applies the 'value if true' condition even if the criteria aren't met. Kindly advise what option do I have. Thanks CRITERIA: This formula checks if any of…
-
Report to Sheet
Example I have 10 sheets for each client and converted those into reports to get the information in one place. Now to feed the details like count/avg/pivot/sum on dashboard I should convert the report to sheet. because cannot reference the report to dashboard directly. Will there be anyway to shift the data from reports to…
-
Edited CONTACTS - flowing to other sheets
If I edit a contact in My Contacts (the Name portion, not the email), will that flow to everywhere the contact is used (all sheets)? It appears the answer is no, and it takes manually editing each instance of the contant on all individual sheets. Hoping this is not the case, or there's an easy solution or workaround.…
-
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…