-
Conditional Formatting
I am working with a ton of different sheets, about tasks that are being complete or not. I am trying to have conditional formatting where it would be easier to see the tasks that are needing attention compared to those that are complete. I have found this to be very tedious because I am having to go through each column and…
-
Count how many "On Hold" projects for the Sheet Summary
I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold. COLUMN: Info Still Needed - is a multi select dropdown COLUMN: Complete - is a check box I have tried several formulas with no luck.…
-
Connect sheets without manual cell linking
I have a project roadmap (activity name, start date, end date, etc) and then a separate sheet where we want to pull from the existing project roadmap. With roadmaps, information is always changing or being added and I want the separate sheet to be able to live update when changes are made. I don't think an automated…
-
If Blank return no value
How would I eliminate the #INVALID VALUE entry when the Start Time is BLANK? Thanks for your help! Here is the formula below. It converts time to Military time. =VALUE((VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) - IF(VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) = 12, 12, 0) +…
-
Filling in a Form field to show a list from a sheet
Hello. Smartsheet GRID file contains a Client Master List. Client Master List has Client Number and Client Name columns. My Travel RSS Schedule Request Form for assigning Techs to Clients for travel, asks for the Client Name to be entered into the Form. So, what I’m wondering is, can Smartsheet query / lookup on a Form…
-
Contact name appearance is different across sheets
Hi, Please can you tell me how I can fix the way my contacts are appearing across 2 sheets. In one sheet I get 'Name Surname', in another sheet for the same person I'm getting 'name.surname@codomain.com'. This is happening for 3 out of the 10 people in that sheet so not consistent within the sheet. How can I standardise…
-
How do I set several cell values to a specific value in a different column
Hi, I am running into issue and I cannot think about a way to solve it. I have a column (Drop-down list) containing specific statuses (Status Column) which I need to match to 5 different report statuses (Not Started, In Flight, On Hold, Cancelled, Completed). The match is as follow: I can match the "Not Started" and "In…
-
Join/Collect Function if status of row within hierarchy is "Next Up"
Using the [Next Up] Column in row1 (the parent row) I'm trying to join the [Onboarding Effort Name] and [Due Date] text of whatever row has the "Next Up" status. The task labeled as "Next Up" will continue to change, the hope being that the "Next Up" row will auto update with the task name and due date of whichever row is…
-
Formula that counts based on two variables by month and year
Hi Community, I was able to find a formula here for counting how many times an employee was assigned to a task by month and date. =COUNTIFS({Administration and Support Task List Range 3}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021), {Administration and Support Task List Range 2}, "Employee") I'd like…
-
Counting Multi Select Drop Down Data in grid
I have a ticketing system for guest responses in a satisfaction system. While I read the comments, I'm manually assigning over arching buckets based on that comment - e.g. Cleanliness, Maintenance, Service, Condition, billing, facilities, etc. I probably have 40 + buckets based on comments. I'm looking for a way to create…
