-
Conditional formatting does not appear to be working correctlyl
Hi, I set conditional formatting to turn a row red if the due date is past; however, today is 3/5 and an item was due on 3/4 and it is not red. Other items due on 3/3 are red. I do have another rule that says to turn it purple if it is in the next 3 days. The row is purple, not red. I also move the items around thinking itโฆ
-
Kanban WIP limits
Hei team, Is there a way to set WIP limits to the columns in the card view? IE if a team shouldn't have more than 5 cards in their 'In progress' column, and no more than 2 cards in their 'Blocked' column; is there a way to either prevent new cards to be moved into that column, or change their color to indicate they'reโฆ
-
Concurrent Approvers for a single row
I'm stuck. I created a change management form that needs at least 4 approvers per submission. However, I need the approvals to go out concurrently instead of in succession. What is the best way to do this?
-
How to delete Sample Users
I loaded some sample Smart Sheet templates when I first signed up, but am no longer using them. However when I go to my Assigned user dropdown, I'm still seeing "Billy Haynes", "Julie Buris", "Robert Coleman" and "Tina Harris". There are NO rows assigned to these people. And I only have ONE sheet. I'm on a minimalโฆ
-
How to share a Dynamic view?
I tried to share a dynamic view with requesters, but some of the E-mail can not show up in the shared user list....? Also how can I share with the domain so everyone can access this dynamic view since I already restricted to requesters based on contact list already?
-
What is wrong with my IF...AND stmt?
=IF(AND([# of Days Open]@row >= 22, Status@row = "Pending Review"), "Red", IF(AND([# of Days Open]@row <= 14, Status@row = "Pending Review"), "Green", IF(AND(Status@row = "Pending Review", AND([# of Days Open]@row >= 15, [# of Days Open]@row <= 21), "Yellow")))) In my calc above, it was working fine until I added the 3rdโฆ
-
Form text entry field displays last entries
In a Form, the fields that are text free-form entry fields will display the last several entries in a box. How do you clear those entries and prevent the form from displaying the most recent entries? When you click in the field, we do not want anything to display - just type.
-
Having an alert trigger at the same time an item is moved to an archive
I have multiple workflows that now need archive automations so they can continue to operate. For one ticketing process, the requestor needs an alert saying that their request is complete, and the request needs to be moved to the archive. The requestor is no longer receiving those alerts. Is this because it is 'moved'โฆ
-
Filter the Absolute Row Number
Hello, I have an odd request. Is there a way to have a filter so that it always shows the first 25 rows of a sheet and hides everything else below that number. I'm talking about the absolute row number. It needs to be a filter. We have essentially a list of tasks that are sorted by a number of criteria. I want my team toโฆ
-
Report Group By Feature not Working
Hi - I am the owner of a report and backend sheet. I have shared the entire workspace with someone and they cannot change the grouping in the report. It's grayed out. They have a license (Enterprise Premier) and their permission level is set to Edit-able to share. Also, if someone else adds a filter to the same report,โฆ
