-
Smartsheet webhook subscope weird behavior
I have a sheet on smartsheet that looks like this: I wish that when `test_trigger` column in the sheet got changed, smartsheet can send a notification to my AWS API gateway. So I use webhook with subscope to setup the notification. However, I can't tell which cell in `test_trigger` column got changed from the request sent…
-
Calculate Reverse Date Format
Hi dears if someone can help with this format I have 3 cells: 1-ESTIMATED REQUIRED DELIVERY DATE: include the estimated date of delivery 2-PROCUREMENT TIMELINE: autogenerated including the number of working days 3-PR ESTIMATED SUBMISSION DATE: I need to create a formula that can automatically calculate the reverse date of…
-
#INVALID Ref in metrics sheets
Metrics were working fine until today then the above appears in place of all formulas = dashboard not working too
-
Exporting Smartsheet to CSV (for JIRA import) without losing our comments
We have a team using Smartsheet that will be moving to JIRA in the coming months. I have seen here that one my export a Sheet as an Excel file, but the comments come on a second tab. In order to import this to JIRA, it will need to be in CSV format which can only support one tab.…
-
Projects rolling over from 2021-2022
Hello, I' currently working on our 2022 project sheet and it has identical columns from our 2021 sheet with changes to the projects that are listed, however, we have some from 2021 that are transitioning to 2022. Since they are still going to be working on the projects for the remainder of the year, I want to have project…
-
How to copy a sheet without updating system generated columns Created By and Last Modified By?
I would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as a new sheet, all of my rows in the new sheet get messed up because many columns contain formulas that extract the data…
-
How to reduce Excel spreadsheet to 400 max. columns
How to reduce Excel spreadsheet to 400 max. columns which is the limit for importing the sheet into Smartsheet?
-
Reports - How do I create a report to give me the flag column?
I created a sheet that has a Flag column. I built a formula in the flag column to indicate when a number is within a range. =IF([Total of Buckets Weighed]@row < 25, 1, IF([Total of Buckets Weighed]@row > 35, 1, 0)) - This formula works fine. The problem is when I am creating a report and the flag column doesn't appear with…
-
Is there a way to pre-populate past survey responses by user?
I have a feedback survey(form) that users fill out a few times a week and I was wondering if there is a way to have their responses pre-load from the last time they answered. For example, say they fill out the survey three times a week and nothing has changed over the course of the week and they want to submit the same…
-
INDEX/COLLECT Formula for gathering list of data
Hi, I am not sure if INDEX, MATCH or COLLECT will be the right things to use in this formula but I'm very much a beginner in using those functions. On Sheet 1 I have a massive list of Restaurants (Column 1: Restaurant Name). Also on that sheet is Column 2: Division (For example Tampa Bay Restaurant is in the Southern…
