-
Unable to get an avg percentage for some depends for a report
I created a summary report that shows percentages for each task under high-level management. The issue that I am having is when I summarize the percentage column using average. The high-level manager does have a percentage, instead has a NaN. The percentage column is an IF OR statement using quotes to hold the percentage.…
-
I need help with a formula or direction if a formula isn't the best way to go
In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?
-
Sorting in Card View
When I sort the sheet with conditional formatting it works fine. When I change to card view, it seems to lose some of the sorting. Any thoughts?
-
Anyone use SS for work order management?
Every month I have 40-50 customer sites I need to visit to complete tests or inspections. I want to ensure I'm being as efficient as possible and using SS to its full potential. I'm happy to screen share and/or teams video-chat to show what I've done thus far. Also, I'm curious if anyone knows how to change all card colors…
-
Trigger a warning - either via automation or conditional formatting
I have a master sheet that I'm using to track the progress of roughly 100 other sheets. I'm pulling in data from those individual sheets of the various status of accounts. What I'd like to do is have an automation so that if the numbers don't change after a week, an email goes out. Or at a bare minimum conditional…
-
Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
-
Conditional Formatting Based on Number of Characters
Is it possible to apply Conditional Formatting to a cell based on the number of characters in the cell? I can think of how to do it using a helper column, but I'm curious if there's a way without adding an additional column.
-
Help with Conditional Index Match
Hello, I have a sheet titled Copy/Paste Data with a column that has multiple text values. I have another sheet titled 23-24 Status. I am trying to conduct an index match on sheet titled Copy/Paste Data when a specific column within this sheet contain the text SNP but keep getting #UNPARSEABLE error. =IF({Copy/Paste Data…
-
Can I used conditional formatting to high duplicates in reports?
We have several grant programs within our organization and I am working on funneling all the form submissions from each into a main report. I would like that report to identify duplicate submissions so I can consolidate and make sure candidates aren't overwhelmed by having too many cases open. Can I use the conditional…
-
Conditional Formatting - Select # of days in past
Conditional formatting should have an option that is relative to days that have passed. I simply want a cell text to turn red if the date is 2 weeks (for example) in the past. The existing conditional formatting options are so close. "In the last (days)" and "in the past" are nearly there. It would be something like "is…
