-
Random circular reference
I have countifs formulas that work 99% of the time but every now and then when I login and look at the sheet, all of the forumlas display "CIRCULAR REFERENCE". I can't imagine that it is actually a circular reference so I'm wondering if it's perhaps a smartsheet bug. Any and all advice would be greatly appreciated.…
-
Customized Message in Workflow
I am trying to create a ticket system where a staff creates a ticket via a form Lets say "Fix the broken faucet" I then want to send the user back an email saying Your Ticket number ABC-123 has been created Then the user can contact a plumber and say please reference Ticket Number ABC-123 for your work I was hoping I could…
-
Disable Notifications/Reminders while "building" schedule?
My team and I are getting notifications and update reminders for sheets that I am still building (it is a copy of another sheet I'm using to create a template and it has all the built-in notifications we eventually want). Is there a way to "disable" the notifications until the schedule has been baselined? I don't want to…
-
Contact list in forms
My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of available options - but the same feature is not available on through a form. Is there a…
-
Date is Within the Next 5 Days
Hi Smartsheet Community, I'm authoring a production schedule and one of the columns automatically populates status (complete, in progress, not started) based on a formula. For a specific row, I need it to display "In Progress" if the start date is within the next 5 days. Is this the correct formula for this? =IF([Start…
-
SmartSheet Recent Update - Attachments/Versions
With the recent update to SmartSheets, our company has seen a few issues. The first issue has been the version numbers. If you look at the example below, the version numbers are out of order. We deal with a variety of freelancers that don't work for the company, but rely heavily on the version numbers. Now with them being…
-
Send automatic reminder Notification on 1st Day of every month
I see lots of posts on end of month, but can't find what I need, which I thought would be a common request. I have a column with the Status of Action Items e.g. Open, Closed, Returned, Not Started etc. On the first day of every month I want to automatically send a reminder Notification to all owners of Open and Returned…
-
Remove Predecessor Link
I accidentally drug a line to link two tasks, they are not dependent on each other. How do I remove the predecessor line?
-
the start of a squeeze? what is the community view?
The email below is the start of a squeeze, the direction of which I’m uncomfortable with and which is ultimately designed to force the switch of collaborators into license holders. Removing ‘View Cell History’ from collaborators is a particularly unwelcome surprise. From: Smartsheet Team <productinfo@smartsheet.com> Sent:…
-
Black out dates in a form (date type column)
Hello, I have created a form and have a column named "Date Item is Needed" which is a date type column. However, the requestor needs to allow at least 10 days from the actual day. Is there a way to always black out those 10 first days? Thanks!
