-
Last recorded date by User - 2 month reminder
Hi All, I want to create a simply usage log for equipment (CMM), we want users to keep skills current, so they record when they log-in. We then want automated reminders / notifications if the user hasn't used the equipment for 2 months ('Related Email Address' field). The puzzle for me is that there will be multiple…
-
Timeline widget in Smartsheet is taking the wrong date
Hi all, I am creating a dashboard make the cutover dates for parts more visual for the stakeholder. My smartsheet has two columns with dates. Last Update CutOver Date The timeline widget is always taking the "Last Update" for showing the part in the timeline widget, but I need the CutOver date. Do you know, how to adjust…
-
Be able to export large reports > 20000 rows
Report does not display detail lines in Grid view if it's beyond 20000 rows. However, it does display it in Table (preview) mode. I would like the following 2 enhancements to make viewing the reports easier: Be able export detail lines regardless of the limit. Provide export option in Table (preview) mode.
-
Please I need an escalation point - customer service
To whom this concerns, We have bought corporate licenses - there is a pending issue on the security which has not yet been resolved. We are trying to connect to our customer support - unfortunately he has not been able to support, communication takes weeks sometimes to be responded to, and it has been ridiculous that we as…
-
Email Notifications with empty cells
Dear all, I have set up an automatic email notifications which should be sent once any cell of a row has been changed. The problem is that the email contains all columns and not only the columns with added or changed cells. Is there a possibility that only the affected columns (all columns which have been filled in and not…
-
Smartsheet Automation Problem
Here is a very simple automation which says that if a row is added or changed, and the value of Status is blank or 'On Hold', then change it to 'Backlog'. Now i add two rows, first has status blank, and second has status 'On Hold'. The automation changes the value of second row and not the first. Anyone has an idea why? Is…
-
Modify Sheet Summary field
Currently have a field in my sheet summary with this formula: =COUNTIFS(Finish:Finish, <=TODAY(+14), Finish:Finish, >=TODAY(), [Helper Parent Column]:[Helper Parent Column], <>"", Status:Status, <>"Complete") I would like to add if the Status is "Not Needed". How do I modify the formula?
-
Current Date + 6 months
Hello, I'm trying to figure out how to designate (highlighting or change text color) a Project that has an end date of 6 months from the current date within a grid. Here's an example grid. I figured out conditional formatting using a certain number of days but is there a way to do a specific number of months? Thank you.
-
CTRL+e for details conflicts with Chrome Browser shortcut / hotkey
Typing CTRL-e in the Chrome Browser opens a Google Search in the address bar instead of showing the details view in Smartsheet as intended. Can you think of any way around this conflict?
-
How to combine multiple project plans into one, but keep separate editing access?
I am running a program that contains 17 different workstreams, and each workstream has a separate PM that is running their own individual plan. We want a view where you can see all of the workstreams together in a 'program' plan. We consolidated all plans into one but this has created a large number of issues as we have 20…
