Multiple IFS for calculations

Hi,

I have no problem doing this in Google Sheets but I'm not sure how to do this in Smartsheet.

I have columns that contain THC and CBD content, measured in a number of different ways, including percentages, mg, percentage ranges, etc., but they're always consistent units of measurement across the row.

I need to calculate the following:

THC>CBD = THC

CBD>THC=CBD

Equal THC/CBD=THC

Blank=Leave blank

I'm not able to get all of these IF statements to work together, I get a number of errors depending on how I structure the formula.

Any suggestions?

Thank you,

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Rachel,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

rachel1073

Hi Andree,

Please see the attached image for an explanation. We currently are exporting into Google Sheets to do this calculation and re-importing the data.

Thank you!

Annotation (1).png

Dave TIppet

Hello,

Below is a basic statement based upon the information provided. Hopefully this will help you get started. Copy code below into top Cell "Active Cannabinoid" column and drag down results to remaining cells in column.

=IF(ISBLANK($[THC Per Unit]@row), "", IF(ISBLANK($[CBD Per Unit]@row), "", IF($[THC Per Unit]@row > $[CBD Per Unit]@row, "THC", IF($[CBD Per Unit]@row > $[THC Per Unit]@row, "CBD", IF($[CBD Per Unit]@row = $[THC Per Unit]@row, "THC")))

Regards,

Dave

Andrée Starå

Happy to help!

I saw that Dave answered already!

Let me know if I can help with anything else!

Best,

Andrée

rachel1073

Wow Dave this is awesome! Thank you so much

Paul Newcome

The only issue I could see arising from this though is that the numbers are being stored as a text string. You may need to pull the numbers and convert them from text values to numerical values before you can get an accurate comparison.

Sign in to join the conversation!

Quick Links

Trending discussions

Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…