-
Best Practices for managing 60+ projects in Smartsheet
Hello, I am a fairly new user of Smartsheet and have recently started at a construction company as a project manager where we design manufacture and erect large steel buildings for rural and industrial use. (From farm sheds through to aircraft hangers and fabrication workshops.) We have up to 70 projects active at any one…
-
Users start new conversation instead of Replying - suggested enhancement
Any other admins out there notice their users start a whole new row conversation when they should just use reply to the existing convo? It's a fine point but I see it over and over again, in multiple organizations. I think the UI just needs a little tweak. Something like one of these two ideas maybe? In the first one, I…
-
Active turn around times by status of a row
I was wondering if theres a way/formula to track the amount of time a line stays in a certain status. For example - If we are using a line to track the life cycle of a contract we would have a created date field and a contract status field. The status field would consist of fields like "Contract Review" "Legal Review" "On…
-
Format of Automations
Apologies in advance if this has already been asked, however, I struggled to find an answer on this when searching in both the community pages and the help guides. I'm convinced I've previously been able to apply a setting on automations, such as alerts/notifications, which allow them to be displayed either vertically or…
-
How to show a "Completion Status" column based off of certain cells containing value?
Hello Smartsheet community, I have a database containing the amount of training specific employees have received. I would like to create a formula that is able to recognize what level someone is at and then the training needed for that level. If they have received the training it would show as "complete." If they have not…
-
Referencing Multiple Columns in another sheet to Match a Location and Date Range to a Project
So I have been looking through the community for a while and have seen a couple solutions mildly similar to what I am looking to do, but can't quite get it right. Feel free to link me to another solution if you feel it would solve this problem: I have a reference sheet which I do not own that contains a listing of Tasks…
-
Copy New Row, Delete Old Row
I have a quick question. I have a process by which a row gets copied (from Sheet A) into another sheet (Sheet B). Since there will be duplicate rows in Sheet A, I'm wondering if there is a way in which when the row gets copied into Sheet B, a row can be deleted if another already exists? Essentially, I'm looking to avoid…
-
A formula pulling Time from a System-Generated column does not stay consistent. Please help!
I am using a formula to pull the time from a system-generated column using Created (Date). The formula is =RIGHT(Created@row, 8). A majority of the time is accurately pulls that correct information but other times it is off by two hours. For example, the screenshot is showing it accurately. But it will randomly switch to…
-
Dashboards
Am I the only one who truly hates the new Dashboard UI? Since the new UI was introduced, it takes me at least 5 additional clicks and much more time to create a new dashboard or modify an existing one... I used to be able to "Save as New" an existing dashboard and modify it for the project, while keeping the layout. With…
-
Is anyone facing issue with the new Smartsheet dashboards?
Hi Everyone, The new dashboard is not working for us. It is taking ages to load (let alone edit). Is anyone else facing similar issues? Regards, Abhiraj Joshi