Shape Data - Using Fixed List selection in another cell

Started by natelfo, April 22, 2019, 06:13:54 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

natelfo

I have some Shape Data rows setup on shape 1.  One of those rows is Prop.Letter and it contains a fixed list of A;B;C;D.  If I set Scratch.A1 to be =Prop.Letter, then Scratch.A1 shows the selected value (A, B, C, or D) as it should.  If I put a formula in Scratch.B1 =IF(Scratch.A1="A",1,0), or =IF(Prop.Letter="A",1,0), Scratch.B1 always shows 1, even though the value of A1 is changing to either be A or something else.  How can I correctly use the result of the Prop.Letter selection as a valid value in another cell's formula?  I like playing with VBA, but I would prefer that this be a shapesheet formula as it will be a master which will be used in numerous projects.


***Update: I just discovered the STRSAME() function and now it works the way I need it to.  I don't really understand though why "A" on one cell does not equal "A" in another cell.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 149 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1050KB.
Tokens: post-login.
Cache hits: 13: 0.00195s for 26,612 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]