-
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…
-
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.
-
OFFSET FUNCTION
Hi SC, Does Smartsheet have an equivalent of the EXCEL OFFSET FUNCTION ? Thanks
-
Link to cells in a different sheet
Hi SC, I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns. I tried it,…
-
Sending out sheets automatically
Let's say I want to send out my schedule every Friday to a few specified emails. Can I set it up to do this automatically?
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
If(And( Greater Than Less Than)
I am having trouble with the following formula: =IF(AND(Percent1 > 0, Percent1 < 6), "Scope", IF(AND(Percent1 > 5, Percent1 < 11), "AE Selection", IF(AND(Percent1 > 10, Percent1 < 21), "Design", IF(AND(Percent1 > 20, Percent1 < 26), "Bid", IF(AND(Percent1 > 25, Percent1 < 96), "Construction", IF(AND(Percent1 > 95, Percent1…
-
If "x", and checked box y
Hello, I am trying to Check box = If column 1 ="x" and if column 2 is checked = column 3 to be checked e.g. If Column 1 contains "Street Lighting" & Quote Successful Column is checked, Street Lighting successful box is checked I've tried the following equasions =IF(AND(Team7 = "Street Lighting", (NOT(ISBLANK([Quote…
-
Backups and Backup size
Hi, Any advice on how you guys save your backups to reduce the size it takes on your servers? Y
-
Multiple Photo Upload For Webform
Is there a way to load multiple photos/files using a webform. It appears that to upload a number of photos at the same time on a webform you have to go through and click on each image - individually.- It would be great & quicker to make multiple selections if possible.
