-
I need to determine if a date column is blank then it returns a message
Hello, I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable =IF(ISDATE([Request Intake Range 9]1:[Request Intake Range 9]22), "met goal", "did not meet") So essentially I want to…
-
Sheet Overview/Screenshot in Dashboards
Hello, I'd like to create a dashboard for my team where we can see information from multiple sheets at once. These are normal grid sheets, not reports. Is there a way to do this using the dashboard feature? Appreciate any guidance. Thank you, McKenna
-
Filter by color
Is it possible to filter a column by color? We use visual management extensively for some of our larger enterprise projects and filtering by color is helpful. I didn't see a way, not sure if there was a "trick".
-
Worksheet population with Formulas
I have a spreadsheet populated by a form where one field needs to be populated using a JOIN of multiple fields from the spreadsheet which are populated using from entry and another needs to be populated by a VLOOKUP. I've tried assigning the formulas to the blank rows ahead of time and using the Change Cell Value workflow…
-
Error when opening a sheet
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
-
How to add a link back to the dashboard?
I would like to add a link back to the dashboard in the spreadsheets. However, when adding this link to the first row (screenshot attached), it makes it more complicated to use the filter and sort options. Does anyone have a suggestion how best to insert links to dashboards in the spreadsheets?
-
SUMIFS cross sheets for months and years
I am trying to calculate total Amount in sheet#1 below by referring to sheet#2's [Date Sent to Client] and [Related Opportunity: Amount]: Sheet#2: So the Amount in sheet#1 SUMIFS({Sheet#2}[Related Opportunity: Amount], YEAR(Sheet#2[Date Sent to Client]=STC-year), MONTH(Sheet#2[Date Sent to Client]=STC-Month) I have tried…
-
Row height issue
I know that row height can not be manually adjusted like in excel, that's usually no problem. In my case, one sheet has had some select rows height change, as if someone wrapped/unwrapped text or changed the text positioning but the formatting didn't follow. I have un-hid and checked every cell for a spot that may have…
-
Locking Values in Row
I have a column on Sheet 1 that has a formula that references a value on Sheet 2. If the value on Sheet 2 changes, obviously the cell in Sheet 1 updates automatically. I have another cell in Sheet 1 that is a dropdown. One value in the dropdown is "Completed". The values in Sheet 2 may change once a year, as we adjust…
-
COUNTIFS Issues
I am having problems getting COUNTIFS to work. I have two different formulas I am trying to set-up in different columns. I would also like cells that return as zero to change to blank. Does anyone know how I can fix my formulas and also set them up for "0" to change to blank? 1.) I need a formula that counts the amount of…