-
Can you have two different workflows based on the same trigger?
I have the following automations set up based on when the Complete checkbox is checked for a row. When the "Complete" box is checked: Send alert to requester letting them know if was complete Move row to archive sheet It moves the row to the archive sheet but does not send the email notification to the requester. Can they…
-
Index/Collect from Descendants
In this sheet, I have a column [Groups] which is a parent column to multiple "Groups", each of which is a parent column itself to tasks associated with each group. I need help putting a formula in [Start Date] of the parent row that would give me the very 1st value from [Date] column that is a Descendant of [Groups]@row…
-
Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
-
Data Mesh?
So I have 2 sheets, Project Register and Customer Overdue invoices totals. The task I have is to email the Project Manager (Project Register) if there is information on their customers aged invoices, when they have Active projects. We dont want to Data Mesh the invoice information to the Project Register as we dont want…
-
Grid Calendar View: allow font formatting, specifically color and size
Currently the font size is fixed. Suggest ability to allow the font size to carry over from the grid view
-
Grid Calendar View: add box outline formatting option
we can conditionally format the bar color in the calendar based on conditional formatting in the grid. Add ability to include box outline as an additional choice. Example: Priority items get red box outline
-
Smartsheet calendar: Ability to adjust the number of periods
We run by quarters (3 months), and it would be great if we can change the default number of periods – right now the lowest denomination is 4, and we'd like to be able to change it to 3 so we don't have to manually white out the last month that's not relevant.
-
Deactivate all automation on a sheet
It would be great to be able to "select all" when deactivating workflows in a sheet. I create templates and archive sheets and if I forget to uncheck the box then I have to go and manually deactivate each workflow.
-
Power Automate x Smartsheet EU Region
Can Microsoft Power Automate connect with Smartsheet EU Region?
-
Freezing top row OR colour the header row
Am I able to freeze row 1 on a sheet so when people fill out the form, the data imports underneath row one? OR Can I change the colours of the header row like I have with row 1?
