- Conditional formatting not showing up on workflow emails
Conditional formatting appears in all the views but does not appear on workflow emails; if it does, it is sporadic. Conditional formatting has worked on previous sheets.
- Sheet Summary Fields in Notifications
Is there a way to add sheet summary fields in a notification? It is possible to add cells by using {{Field}} but this doesn't work for the summary fields. Any inputs are much appreciated.
- Turn All Automations Off or On
Sometimes i would like to implement changes to a sheet that would trigger automations that i don't want being sent out. One such sheet has several dozen automations. Turning them all off, implementing my change, and turning all the automations back on, could be a faster process.
- Still unable to manage columns even at the Business Account Plan level
Just upgraded to the Business plan but still unable to manage columns - insert, delete, rename, etc. The ability is greyed out. How can I manage columns?
- Best way to truncate people's names (to first name, last Initial)
We have several dashboards /sheets that have people assigned to tasks, sometimes more than one. When the names get long, it can make it hard to fit within the format we're looking for. Wrapping text will increase the row width, while not wrapping means the column has to be very wide. Question: What's the best way to change…
- How to capture/log user/contact info in a cell after updating a different cell?
I want to be able to identify the user when changes are made to cells on the Sheet. I know there is the Activity Log. But I want to see that data on the Sheet. I also know that there is the Modified By column, but that picks up changes to any cell in that row. I have a log that needs to have the status column changed by…
- How can use an other time unit like hours in the smartsheet?
In the project we had durations in hours My plan is in hours but this unit is not available only days and weeks. Can someone do it this before? Regards
- OneNote integration in Smartsheet
Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/section group in one click, and then designate whether to open in the OneNote desktop…
- MetaData Sheet - Grab a cell's data from a whole column for each new "task sheet"
Hello, The image below is the information that is brought in from our main "Intake Sheet" (where we have hundreds of projects listed) and filters through the MetaData sheet to this Project "Task Sheet". Our builder set this up. I added the Absorb Code row, but cannot figure out how to get the information to pull over…
- Cross sheet reference,
I'm writing to you because I'm having some trouble with cross sheet reference formulas. I lost all of the formulas in my sheet, and now when I try to add a new one, it works fine for the first row, but when I drag it to another row, it says "no match." I'm sure that the formula was working fine before, but I'm not sure…