asked on April 27, 2020
•
Show version history
EDIT - Nevermind, I guess Cloud didnt like that table but when I created a brand new one with the same info and formula it liked that variable name better. Just left it as table instead of hours.
Can you use the Index and Row in Cloud on Forms?
I have a table called hours.
I have two columns called phours and shours.
I am using the following to populate the totals.
=SUM(INDEX(hours.shours,ROW()),INDEX(hours.phours,ROW()))
It keeps showing "Calculation contains an invalid variable". Not sure what that would be as I am selecting it from the variable dropdown..
0
0