-
Sheets and Dynamic Views
There are a few existing Sheets and Dynamic Views that were created and still owned by previous employees. Because they no longer have licenses, those sheets are broken/unable to view but still appear in our sheets. Is there any way we can delete these?
-
Pass URL parameters from web ad campaign into Form hidden values
I am running an advertising campaign to get registrations on my Form. When the users click on the advertisement (either ad A or ad B) , they go to a landing page with a URL ending in -----.com/?campaign=launch&utm_source=ad_a , and the form is on that landing page. Parameters are key-value pairs that can appear inside URL…
-
Finding sheet owner
I have a licensed user that has left the company. Who I transfer the sheet ownership will be determined by what the sheet contains. I can see this user has ownership of 1 sheet and I can't easily locate the sheet. Is there a way to determine who has ownership of the sheets in an account? Thanks in advance.
-
How can I convert text names to existing contacts in my account?
I manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed the column on my sheet to 'Contacts' thinking I'd be able to leverage contacts in my…
-
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…