Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Reports: Automatically change crossed-out items?
I've created a report that collects all our ad assets in one place, from multiple sheets. However, all of these ads are marked complete in their respective projects, so they are marked out/crossed out. They're showing up this way on my report and it's not optimal. Can I change the font style in my report so it doesnt…
Has the Community board been hacked? Or did some international posts get on this board?
What's up with the posts over the evening? I'm afraid to click on any of them. I've emailed support to find out what's going on. Tim
Subcontractor needs help
I'm brand new to smartsheet and I'm trying to figure out how to best structure my sheets for managing multiple projects. We're a construction subcontractor with 50-60 different projects in process at any given time - new ones added nearly everyday and other completed projects dropping off. Do I need to set up a separate…
Email alerts with entire discussion
How can I get a "right away" alert that contains the entire discussion as opposed to only the last comment?
Large Corporation Portfolio Management
Is there anyone in the community, with annual revenue > $1B, using Smartsheet as their Portfolio Management tool?
Exporting to DOMO - columns being read as Text not Number
I currently have smartsheet connector to DOMO to create reports; however, the columns that contain financial data come over as text because smartsheet's column properties are Text/Number. Not Text, Number separately. Anyone know how to make this work? or a workarond? Thanks
Append Text before Formula
I have a formula like below: =ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0) How do I append "ETA Week Number" before the result of the formula. I have tried the below, but it comes up as UNPARSABLE =“ETA Week Number “ + ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0)
Asigning special dates in Time Line Display
What I try to make is: E.g.: There is a task for the time between Aug 5th 10 and Aug 18. On Sep 14 partner XY is required to be present in City AB. Is there a way to show the alert icon in Time Line Display linked to additional details? The notification is already possible and the message can be sent to appointed person.…
Reference a row by Task Name instead of by the row Number.
Here is my challenge. I would like to create a formula in a template based on a row's Task Name (Task Name is a column), not the actual Row Number. The Row Number for this Task Name may change from proejct to project so I cannot reference the Row Number. The formula is pretty simple. I have a Completion Date column and a…
Recurring Reminders
Is there any way to set recurring monthly reminders for each row for content which doesn't get updated? I am doing up a rental collection sheet, and need to set reminder for the person in charge on a monthly basis. Thank you.
