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.
Hey All,I have this formula:MAXROW(“Daily
Checklist”,“_Rownumber”,AND([Fault Status]="Fix Immediately",[Asset
ID]=[_THISROW].[Asset ID]))Which works perfectly. Until I hit
save.Appsheet determines this to not return a true or false like a row
filter ...
Hey All,I am trying to use a column that incorporates both Valid_If and
Suggested_Values combined.The suggested Values should provide an Enum
List. The Valid If should determine if another column = X then the value
must be in the suggested values lis...
Heres some context.I created a new table that was going to become a menu
inside the app so a lot of column names had other table names. On import
it created the reverse references. I changed the technique and deleted
the matching column names and it ...
Hello,I have a working slice that shows me specific rows of my Shifts
table. I am using a view to ensure it works, which it does.I have this
action: Which should make [Carer 1 Agreed] blank.I have a bot that is
triggered when a different table is upd...
I am trying to create a list of user email addresses from a list of user
[ID].The list is called [Preferred Candidates] and the Candidates table
has [Email] and [ID] inside.I have
tried:Select(Candidates[Email],CONTAINS([Preferred Candidates],
Candid...
Sorry everyone. I had tried this but I was using what I thought was the
key column. Turns out I was thinking of a different table. All sorted
with key="formula from initial post"
Hey @Suvrutt_Gurjar Unfortunately it says the COUNT() was used
incorrectly. Maybe my Employee column is not the right Type. Its Enum
with a base type of Text.
Thanks guys, It looks like I will have to change the column names to
something similar to make this work. There is over 20 virtual columns.
That will eventually create a massive performance impact once theres
lots of data involved.
