-
CHANGE ON SITE AFTER IS CONFIRMED
I have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I would like when I choose from Equipment Confirmed Arrived” column the option “Confirmed” the column “Equipment Order Status”…
-
Counting number of selections made in a multiselect column cell
I have a sheet that we are using to track partners that attend various meetings. The organizers of the groups select the partners that attend a meeting from a multi-select dropdown list. I need to be able to count how many partners are marked in each of these cells individually. For the screen shot below what I would need…
-
Sumifs with cross sheet reference and date criteria
I am trying to create a formula on a separate sheet that adds up the data from the sheet shown below for quantity of chairs, "Chair 2 Qty.", that are a specific type/name from column, "Chair 2", and have a construction start date, "Construction Onsite", that is in the future. I have it working without the date reference,…
-
How to add a percentage/fraction progress counter for checkboxes
Hi, I have a sheet with multiple tasks on indents assigned to people (names on outdents), each task has a checkbox for when it's completed. Is there a way to make a counter for each person for how many tasks they have that shows how many are ticked? e.g. 20/100 I've figured out the countif to count how many are ticked on a…
-
RAG Symbol won't pull through
Good afternoon Smartsheet Community, I have a collection of different sheets that pull into 1 main dashboard and one of sheets's Red/Amber/green Symbol wont pull through and i cant for the life of me work out why. Please could anyone give any tips/tricks? Thanks in advance
-
NEED TO ADD LAST COMPLETION DATE IN COMPLETION DATE COLUMN
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last row that changed to "complete" status. NOTE: The Record a date automated workflow…
-
Can I use a sheet to define notification contacts in another sheet?
I have multiple people wanting to be notified when certain criteria occur. I have that information in another sheet. For example Mary wants to be notified if A, D and Z occur and Steve when B, C and D occur. Mary is a row in the sheet with checkboxes for the criteria she wants to see, Steve the same. Any thoughts?
-
Any reasons why this formula stopped working?
Hello colleagues, Hope you are doing great. I have faced problem with this formula which was working before: =IF(VLOOKUP([W/O]@row, {PAML Reg. 014 - Document Error Register Ka Range 1}, 8, false) = "", VLOOKUP([W/O]@row, {PAML Reg. 014 - Document Error Register Ka Range 1}, 5, false), "") So basically this formula brings…
-
How to use multiple IF and AND functions for symbol formula
Hello Everyone, I have a basic project sheet with Start Date, End Date, % Complete Columns. I would like a formula for Symbols to do the following: Gray = If todays date is less than Start Date Red = If todays date is greater than due date AND % Complete is less than 100 Yellow = If todays date is less than due date AND %…
-
Formatting on Smartsheet workflow notification
How to make formatting using HTML tag or using CSS for workflow notification (for Alerts and Approval Request). Its very useful for and impressive for user attraction to highlight the few area for example: A workflow has 6 approval step (3 for verification and 3 for approval). we can highlight the user status of approval…
