-
Need help adding reminder date to a column
I have reminder set on various rows in the sheets in my Smartsheet. Is there a way to have the "date" that is set on each reminders displayed in a column on the same row? In the attached screenshot... Row 1... the reminder in the "i" column is set for Wed, 12/27. The project isn't due until Fri, 12/29. But the next…
-
Status auto change
Hello, I was wondering is it possible to make the status RYG color changes when it is closer to the due date? For example: it shows red when it is due two days before the date and so on... Is there a formula to right and what is the formula? Thanks a lot
-
Checkbox checked, cancel RYG
Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click…
-
Reminder Notification Emails
Is there any way to customize what columns I see in reminder emails? We had a client which recently took control of a worksheet we've been using and I no longer have admin rights. Before, I had made a "dummy" conditional column to change when needed, then I would send myself a nice clean Notification. So is there any way…
-
Moving Sheets
Is it possible to move a sheet into a folder using the mobile app?
-
Using Smart Sheet To Make Appointments visible to all marked in Team
Hello , i am using smart sheet for some time , i face several issues I need expert Opinion on : 1 - I have the Data Base in One Master Sheet , From there i want to assign different tasks to different teams . For each team i have made a seprate sheet. I want that the data could be transfered to the teams sheets by a click ,…
-
DataMesh config scheduled, but not executing
We are using smartsheet to share information between functional groups and DataMesh is the primary tool used to copy/paste the information between sheets. Recently (within the last two weeks), I have come across several datamesh configs that are not running during scheduled times. If it is set to hourly, the datamesh card…
-
Filter doesn't auto-apply
Dear community, I'm a bit new, so apologies for any newb question. I have applied a filter but any time a field is changed (and therewith it should disappear due to the filter), it stays there until I open the filter again and click 'apply'. Is this true also for changes made by my colleagues; do I need to re-apply the…
-
restrict users from editing curtain fields
Is there a way to restrict certain users from editing curtain fields? For example, we are using Smartsheet so users can enter info waiting for approval, but we want only admin should be able to mark off "check box" for approvals.
-
SheetNames appear differently in SSIS compared to SmartSheet
Hello, I am trying pull the information from Smartsheet Dynamically using SSIS. I see that the Sheet Names in SmarSheet is different to what I see from SSIS ODBC Source. For Example : Names in SmartSheet Displayed Name in SSIS * 801 Centre Road 801 Centre Road__8524479023343492s_(Home) * Canterbury Road Canterbury…
