Sign in to join the conversation:
Is it possible to have .5% as a percentage. Whenever I put .05 it rounds to 1% and .04 rounds to 0%.
Thank you
Hi Kari,
Yes, it is! You need to adjust and increase the decimal. (see attached screenshot)
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
