-
Automating RYG balls based on Due date and completion status
Im having an issues creating this formula and was hoping someone could help improve on my formula. Im trying to create a HEALTH flag marked "Green" if the task is not due today, "Yellow" if the task is due today, and "Red" if the task is past due. However, the HEALTH flag should stay blank if: 1) the STATUS…
-
Error message - publishing SmartSheet calendar to Outlook
I played around with the publishing calendar functionality using ICal and syncing it to my Outlook account. I eventually decided not to use this function and turned it off in SmartSheet. Several times a day I am getting an error message in Outlook related to publishing the calendar. See the attached screenshot. Any ideas…
-
INVALID COLUMN VALUE
I wrote a function for my budget, setting limit and i want it to return text either True or false. but it kept on returning "INVALID COLUMN VALUE" (=SUM(A3:A10)<=(0.7*D6)
-
Form not capturing submissions
Hi, Am experiencing an issue on a brand new sheet/form where submissions are not being captured. No filters. No hidden columns or anything. Shows that five entries have been submitted (all my tests), but nothing is showing up on the grid view. It's a blank sheet even though I see the confirmation pop-up and the pop-up that…
-
Enhancement Request: Dropdown for Forms
Quick request, likely will come to naught, but here it is: Several uses cases recently require designs with multiple forms. Useful would be a convenient way for end-users to access them (for submission, not editing). Perhaps a dropdown maybe in all that wasted space in the new GUI design* Other solutions, like a Dashboard,…
-
Updates are not visible
I have a MSFT- Promo account and a month ago I created recurring Update Requests that are being sent out to my 17 customers. Since the upgrade last week, I cannot find the Updates that I created but they are still being sent out (yes, I checked Alerts and Actions). I keep getting a message "Upgrade to Business or…
-
Reminder issue?
I have 20+ sheets with various Due Dates on various rows. I have a reminder set to send the Preparer a reminder when the Due Date occurs. Historically, the email notification only shows the rows that are the actual "Due Date". However, today, it sent the entire sheet and all rows which defeats the purpose. Are there…
-
Conditional Formatting Not Working
Hello, I've set my CF rule to look like the screen shot I have attached. I've been over it for what seems like 100x but it's just not working. Can someone please help?
-
Adding Contacts
I understand when you add a new contact name you have to associate an email address with them. I don't want all my new contacts to get a notification from Smartsheet that they have been added, until they are assigned to a task. My question is: Does Smartsheet send emails when people are added to the contact list?
-
Please give TIME data type support
Hello guys, Do you have any plan on providing to the user support for TIME data type? I think Smartsheet is a good product, but, the lack of this feature is really disheartening. I'm sure it's easy said that done,b ut, would really appreciate seeing the support for it. thanks. -Yasutaka
