Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Good day All:
How do I get my formula to display in decimal format? My formula currently display 1 but should display 0.5.
[C5]14 = 7600
[C6] 14= 3800
Formula: =IF([C5]14 > 0, ([C6]14 / [C6]14))
Thanks
Hi Kam,
According to your formula, you are dividing the same field into itself.
Any number divided by itself is 1. Perhaps one of the two references in the second part of your formula should be [C5]14?
You are absolutely right! It is amazing how we miss the obvious. I made the change and have 0.5 displaying.
Thanks and sorry for the inconvenience
Not an inconvenience at all! 2 sets of eyes are better than one! Glad I could help you out!
Looking to calculate the % of empty cells in a sheet for all rows that have data, with the intention of excluding any rows beyond my last row. I'd like to use this to motivate relevant stakeholders to completely populate the columns. Thank you.
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
I have an Action Log and in the log we have a column that identifies the different projects our team leads. There is also a Workstream column, which identifies what workstream is responsible for getting the answer. There can be more than one answer, so we have a dropdown and if multiple workstreams are responsible for the…
