-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
Problem to move infos from one sheet to an another
I have a problem with my Smartsheet sheets. I made a mistake and instead of copying datas from one sheet to an another, i have transferred datas from one to the other sheets. After this manipulation, I deleted a lot of info in the new sheet because these infos were not useful. Today I want to come to the oldst version of…
-
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…
