-
Alert and Update Request in Same Workflow but Alert doesn't fire?
Hi All - maybe someone can spot what I'm missing here. I have an Automation that fires when our Admin sets a specific status column. When the value is "In Progress" it is supposed to send an Alert to the Requester, an Update Request to the Admin (or Admin and the Admin Backup) and then it sets a cell value (this step is…
-
Why is my Automation moved the whole sheet rather than just completed
Why is my Automation moved the whole sheet rather than just completed
-
Date range and access issue
Hello, I have two issues with Smartsheet. Despite being granted a full admin user license, when I click on the 3 dots in a column, I cannot utilise most of the options on the drop-down menu, for example, I cannot lock a row, insert or delete or rename a column, I cannot edit column properties etc? When viewing my sheet in…
-
Sheets > Timeline View > Fix scroll bar time-jumping
I opened a support ticket reporting this bug and the agent suggested I open the idea here. Currently there is an issue where if you drag the slider bar at the bottom while in Timeline View, it will "jump" drastically into the past. I've gone as far back as 2001. Note - there are no dates on my sheet before January of this…
-
Count how many per Month and Year for Summary Sheet?
Hey - I'm trying to create a summary sheet for photo data. I want to count how many Photo shoots are happening per month/year. The screenshot is below is our "Comp" sheet that has the data I want to pull for the summary sheet. So ideally, I can then create a graph for a dashboard. The AI generated this formula:…
-
i am no longer owner of my own workspace and now i am marked as editor how???
am in a meltdown sitution where am stuck with my own workspace with lots of datasheets i can't do anything. how can this happen. so this worksheet have no longer owner somehow i have not transfered my ownership owner status stuck on loading (see image attached) contacted help desk and they have replied me to copy the…
-
Formula to summarize orders of 1-10 products within 1 column using info from other columns
"Trying to create a summary column that lists (on a separate line) the 'order' for shipping of 1 to 10 items. Ideally, if 10 items, it lists all ten (item description,# & units) on a separate line if 10 items are requested, if only 1 requested, then it only lists 1. I have done an If nested statement that worked but when I…
-
COUNTIF with dates?
Hi team! So, I have a date column with the date where a row is created "Created date" in my sheet. I'm trying to find a way how can I count how many rows are created in weekly periods. I have in my metrics sheet 2 columns with the ranges: I need in column 4 something like a: "Countif ("Ceated date" in between dates in…
-
Suggestions for Risk Register Reporting
We have created a blueprint for all projects to have the same workspace within Smartsheet. Part of this includes a mandatory Risk Register that all projects are required to update monthly. I'm in the process of creating portfolio reporting for my leadership team that includes an overarching dashboard and some separate…
-
Automation for existing date
Hi, Need help I am working on my Smartsheet where I have to Record a date automation needs to work. When I clicked on run it has changed my existing date to new date (today's date) is there a way to revert the automation to correct existing date. Thank you
