This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Looking up values from two different rows of the same column

Posted on 01-04-2023 03:38 AM
Eera_Pendharkar
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I need to use the values in the first and second row of the column 'pipe ID' to calculate value for another column.

The corresponding formula used in the spreadsheet is

=IF(K17="","",K16/K17)

How can I perform the same operation in appsheet?

Eera_Pendharkar_1-1672832019077.png

 

 

0 1 119
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

https://help.appsheet.com/en/articles/2355953-if

https://help.appsheet.com/en/articles/2357309-lookup

 

Top Labels in this Space