Discussion List
FORMAT ROWS WITHOUT CHILDREN ROWS
I have set up a sheet and found a solution to automatically highlight parent rows (using a helper column) but is there a way to also highlight rows automatically that don't have children rows?
Unable to get the formula correct to merge my data from multiple columns into one column.
Auto-calculate a date but round to nearest weekday
I a creating a smartsheet that is calculating several milestone dates based on a single event date. This is the formula I'm currently using to calculate a milestone date 8 weeks prior to the event date, based on the event date being manually entered in the [Milestone Date]16 cell. Is there a way to make this return the…
Changing the account license email
Hello I hope you are doing well. I would like to change the email that is connected to my license. Is there a way i could change it ?
Is there a Smartsheet template called "DAM Insights Dashboard" ?
I have connected Brandfolder and Smartsheet. Then, I would like to build the DAM insight dashboard easily. However I could not find it yet.
How to show/convert days to weeks on project plan
Hello All, duration column circled in blue is automated as per the project setting circled in red is all manual I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days is there a formula I can use on another column to…
Multiple Hyperlinks
It would be extremely helpful to be able to put multiple hyperlinks in one cell.
Replace user
When an unlicensed user has left the company and is replaced by another one, how do I easily replace that person's name by another one throughout several sheets in several workspaces?
Dashboard issue
Hello there I have an issue when i create a dashboard, the colors of the cells disappear when i save the file as pdf. I use Smartsheet for KPIS and it shows the color of the percentages result as i set it up in different colors based on the performance, but when i save the fil all the colors disappear. Please see the…
I want to add a formula to my sheet where i can calculate the current month last working date
I want to add a formula to my sheet where i can calculate the current month last working date from the date entered as the last working date