-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
-
Copy row to another sheet help
I have a Task Request sheet that has a column listing the name of the Project to which the task belongs. When a new task is created (from a form) and the requestor has selected the Project it belongs to, I would like to create an automation that copies the task row to sheet that has the same Project name. If there's a…
-
URL Query String and CHAR() Function Helper Sheet
Greetings all, Because I grew tired of spending an inordinate amount of time piecing together URL query strings, I've compiled all of the UTF-8 character codes (that I came across) into an easy to use reference sheet. I've also added in a column for the corresponding CHAR() function codes and conditionally formatted the…
-
Alerts to MS Teams: Was working for years, now asking to add organization
Hi all, I have several automations/workflows set to send alerts to MS Teams. The channels are public and the alert settings are unrestricted. They worked just fine for several years. Suddenly, this week I received emails that the workflows couldn't run. When I checked them, the organization was no longer selected. I tried…
-
How can I obtain the URL for a form that is attached to a sheet ?
I need to obtain the FORM URL that is associated with a sheet that is copied via API so that I can populate the URL in a cell. I was reading over the API documentation and cannot seem to find where this is possible. I know this has been asked sporadically and apologies for the duplicate asks, but this seems like such a key…
-
Add custom sort button to ribbon
I have a sheet that uses all three tiers of sorting (and could really use a fourth). Every time my sheet updates with new content from its linked form, I have to re-select each tier for the sort. Excel saves the last custom sort, so, even though neither has an automatic sort capability, you only have to do a couple clicks…
-
Smartsheet API - Is it possible to create a copy of a sheet and maintain the row and column IDs?
Is it possible to use the Smartsheet API to create a new sheet from a copy of an existing sheet, but maintain the row and column IDs? Ideally the output would be 2 sheets with unique IDs, but the row and columns within each would have identical IDs
-
I want to be able to hide my formulas from being viewed when you hover over the cell.
I have a sheet that has a lot of complex formulas and is used (and edited) by many users. When the users are referencing the sheet, the formulas show up and get in the way of reviewing the data. Is there a way I can hide the formulas from popping up when others are using this sheet to edit? All of the columns with the…
-
Is there any way to retrieve data that was deleted from a sheet?
If a grid sheet had 1879 rows of data in it and all of those rows were deleted, is there any way to get all of the deleted data back after it's been saved? I tried looking at the Activity Log but it doesn't show the data and I need it restored in the columns it belongs to. Is this possible?
-
After filling the form, no data income on the Sheets
WHAT's wrong? I created few sheets, just one sheet with this issue.