Hi Friends
I am trying to upload attached sheet in smartsheet but same countif formula is not working in Smartsheet.
Can you please help me to fix this formula for smartsheet.
Thanks you in advance.
Hi Friends
I am trying to upload attached sheet in smartsheet but same countif formula is not working in Smartsheet.
Can you please help me to fix this formula for smartsheet.
Thanks you in advance.
Last edited by NonStopLeo; 11-17-2019 at 09:04 AM. Reason: I found the solution
Could you please clarify what "smartsheet" is supposed to mean? I for one have never heard of that
M2=COUNTIF(E2:L2,"Yes")/COUNTIF(E1:L1,"*")
Formatting as Percentage
Hi CARACALLA
Existing formula in my sheet is working in excel, but when i upload the same sheet to smartsheet. it is not not working there.
I need help to make it work on smartsheet.
Last edited by AliGW; 11-17-2019 at 08:53 AM. Reason: Please don't quote unnecessarily!
You have been asked this already, so please answer it: what is SMARTSHEET?
This is not an Excel question - I'm moving the thread accordingly.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks