-
Return Column Name using a Formula
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these columns. For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a. In my "Status" column I'd like to return "Delivered"…
-
AUTOMATIC Weekly Reminders
I've created a Meeting Agenda sheet that will be used during our weekly meetings. I'd like everyone shared to that sheet to receive a weekly reminder. How can I set this up to automatically send out?
-
change task color in filter calendar view
I'm sure this is very simple as I did it for one of my filters but not for the life of me can't figure it out again. Looking to change the color of my tasks in calendar view when I apply a filter. thanks Mike
-
Missing email collaboration
I keep stumbling over my desire to collaborate with team members via email or discussions. Discussions work OK, but I'd call them "Notes", unless I'm missing something (and I hope I am!). For example, if I want to include someone in a discussion many of the other tools I use let me type "@Ste" and it will popup all users…
-
Notifications - Direct Link to Changes in Specific Columns
Hi SS Community - We're looking to make discussions in Smartsheet easier for our users. Currently we have the notification set to address changes and additions to the comments column. The custom email is nice, but it's not exactly user friendly. Is there a way to hyperlink to an area of a smartsheet where a change was…
-
Weekly Input for multiple data points at multiple sites
We have been tasked to gather weekly meter data: multiple meters (3-10) for each utility (water, electricity, natural gas) at each of the 60 plants. What is the best way to gather multiple data points from mulitple plants all at once? We are unsure how to format this correctly. The plants will have to entrer Meter Name,…
-
Search using wildcard* not locating content in a sheet
Hello, Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results. Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number…
-
"Red" traffic light disappeared
Hi there, I'm currently using a "Red/Yellow/Green" traffic light status in one of my sheets, with the colour that is displayed being based on certain criteria. I've just noticed that the "Red" symbol does not show when it should (it was working fine before; "yellow" & "green" are still working ok.) I have not changed the…
-
Filtering with Start and End date views
I have filters setup to view different tasks on separate calendars. However it only shows the StartDate. Is there a way to enable EndDate as well?
-
Kanban: Delete Columns / Edit Column Values
Can you delete some of the default fields in a Kanban if you are hoping to use it in a nontraditional way (e.g. assigned, size, etc.) Addendum: not finding how to delete any fields actually, even those manually created. Addendum #2: not finding any way to update column values after they've been created. I'm striking out!