I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far:
=IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for
fellow SS users,
My colleague, who has full admin rights, is not able to save anything into a workspace that i have created. I can't see any restirictions in any settings so I wonder how I allow him...and other license holders, to freely add to and use this space.
I can make the formula work if the cell has a number in it but not if it is blank! I've nested IF statements until I'm blue!!!
I'd like to check the text in one column and a check mark in the second column and then get a total count based on that.
The first column is Scope which can be A or B. The second column is complete which is a checkbox that's either checked or unchecked. What I'd like the formula to do is
I would like to have a formula to count items based on a couple of criteria - Status and Deliverable.
I have attached a picture of the columns.
I'm trying to write a formula that'll allow me to look at the color of the RYG balls in some rows, find the lowest color and set that as the main color for the overall project.
So, Project A needs a status. I'd like to look at tasks 1-5; if any of them are red, the entire project status
Hi SS users,
i have been a user of SS for just four weeks and i need to know if there is a self help group for addicts! my first waking thought is about our SSheets and who is collaborating with who and i get excited at the thought that we are getting efficient at work and that we are actuallyu