-
IF and HAS and OR formula combined (or alternative)
Formula wizards! Can you help me with this one? I have a column for Primary Team (single select) and a column for Secondary Teams (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X", is either primary or secondary. Report parameters won't let me do this (because I also…
-
Formula for COUNTIF
We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning). We also have another column titled quarantined and the drop down options are yes and no. This…
-
Formula using <>
I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is: =IF([Late Tasks]@row > 0.75 * [Total Tasks]@row, "Red", IF([Late Tasks]@row <> 0.5, "Yellow", "Green")) Can someone tell me…
-
"Save As New" Not Preserving Cross-References
Hello, I'm building a sheet in which I'm using lots of cross-references in the sheet summary. I plan to use it as an active metric field to display summary information from data in other sheets. I will need to copy the sheet about 30 times. I want to do this without breaking the cross-reference since it would be VERY time…
-
Single drop down 3 selection ( open, closed, cit). How do write formula to count each in column?
Status - Column Heading Open - Drop Down Closed - Drop Down CIT - Drop Down Wanting to count how many "open"
-
nested countif with date criteria
I'm trying to do a countif statement that checks if a request is approved or denied, and the return to work date is great than today's date. I've tried multiple ways and can't figure it out. Any ideas?
-
count if statements not working
I'm trying to get my countif statements to work. I need to count multiple dept IDs in one column, and pulling information from multiple sheets into one dashboard. In one column, the countif statement IS working and returning a calculated number. It looks like this: =COUNTIF({Age 65 and over Range 1}, ="362") + COUNTIF({Age…
-
Scrolling a dashboard inside an iFrame on iPhone - not working
Hi, I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freeze on the report dashboard, and it does, for a couple rows of scrolling. But then I…
-
Protecting Folders From Admins In Workspace
I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain folders can be protected? Thanks!
-
Can update requests not be combined by recipient?
While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple emails?