Best Of
Re: Working with Project Management Office
@Naeem Ejaz No that doesn't work, I have written two replies, performing "Step 4" step by step, but they won't post.
The template, following the instructions simply doesn't work. In fact, I can't even tell you why project SM-004 works. Because as I outlined above, pasting the new project SM-005 results in "no match", I don't understand why. Further if I type SM-004 back in, it returns with that project information and again, I don't know why.
Pete Spin
Re: Add business days to automation
Currently, you can set up a trigger for when a date is reached to run X days before or after a date column. It would be really helpful to be able to specify X business days instead of just X days to account for weekends. For example, we want to be notified if a task has a status of "Not Started" 2 business days after it was added to the sheet. Currently, the only option is to create a helper column with a formula to calculate 2 business days after the Date Added column. However, adding extra formula columns makes the sheet unnecessarily congested compared to building the business day option into the automation itself.
Change font size of form title
It would be very useful to be able to reduce the font size of form titles, i want the titles on one row.
Lisa B 2022
Re: Help with an Index Match Formula - If Error Required?
Hi @Catwah
Try this one:
=IFERROR(INDEX({Survey Home Name}, MATCH(Home@row , {Optician Ear & Dental Care Company Survey Range 1}, 0)),"no")
Have a great day!
Matt Johnson
Widgets auto resizing on Smartsheet dashboard
In Smartsheet, widgets on a dashboard are not dynamic in the sense that they automatically resize based on the content or number of entries. This would be great feature especially for reports.
Sandypearl
Re: Additional Settings for Duration Column
It would be helpful to allow users to input both start and end dates with specific times in columns, and have Smartsheet automatically calculate the duration between them in hours, minutes, or days. This would greatly improve tracking for tasks, shifts, and time-sensitive activities.
Tasneem Modi
Center and middle justify summary fields in a report
I have created a summary field in my Smartsheet that is a formula:
Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY())
Works just great! Returns a number that I would expect.
The challenge is that when I create a row summary report that references the field Overdue Tasks, it pulls in the number (great!) but it's right justified and looks unpolished. Similarly, I have summary fields that are symbols which also get pulled into the report, and those are centered, but top justified, which also looks unpolished.
Is there a way to pull in summary fields and be able to both center and middle justify them? Thank you in advance for the guidance!
VKJ
Re: Lock single cell
This feature has been requested multiple times since 2017. Please look into implementing
Howard R
Re: Users disappearing from Groups
Hi,
I hope you're well and safe!
Unfortunately, it's not currently possible to view group changes in a log, but it's an excellent idea!
Please submit this as Product Feedback or Idea (If it hasn't been added already) when you have a moment.
Please share the link to the Idea here so that others and I can add our votes.
If you haven't already done so, please submit a support ticket through the new Smartsheet Support Portal.
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: Register Now! Webinar: Stop Working the Old Way – Automate the Work
Hi @AmandaWebb,
Yes- the recording is going to be added to this page with the 1st session and eventually all after the conclusion of the series.
https://www.smartsheet.com/contact/smartsheet-foundations
ShelbyHunt