These are real columns. The full error message is the one originally posted. You will see in the text of the expression below that there are 7 “stages” and the 7th stage crashes the AppSheet before it finishes reading the rest of the expression. This is an assumption as the error message shows all but the last bit of the entire expression. I used another table as a reference table that has each stage as a row that then takes the expression text and inserts it back into the data entry view to be calculated. Here is the expression text:
IFS(
[Stage]=1,
CONCATENATE("
Employee does not need to quarantine or isolate.
Employee Guidance:
•You should wear a well-fitting mask around others until “,TEXT([Date of first exposure]+10),”.
•You should get tested at least by “,TEXT([Date of first exposure]+5),”. If you test positive or develop COVID-19 symptoms, isolate from other people and contact us back for updated recommendations."),
[Stage]=2,
CONCATENATE("
Employee does not need to quarantine or isolate and can return to work if they are fever-free for 24 hours without the use of fever-reducing medication and all other symptoms have improved."),
[Stage]=3,
CONCATENATE("
Employee does not need to quarantine or isolate and can return to work if they are symptom free."),
[Stage]=4,
CONCATENATE("
Employee Guidance:
The employee needs to isolate until “,TEXT([Isolation date]),” then if they are fever-free for 24 hours without the use of fever-reducing medication and all other symptoms have improved, the employee will be eligible to return to work."),
[Stage]=5,
CONCATENATE("
Employee Guidance:
•Stay home and away from other people at least until “,TEXT([Date of first exposure]+5),”. Wear a well-fitting mask when around others at home, if possible.
•Until “,TEXT([Date of first exposure]+10),”, watch for fever (100.4◦F or greater), cough, shortness of breath, or other COVID-19 symptoms.
•If you develop symptoms, get tested immediately and isolate until you receive your test results, then call us with those results. If you test positive, follow the isolation recommendations we give to you.
•If you do not develop symptoms, get tested at least by “,TEXT([Date of first exposure]+5),”.
•If you test negative, you can leave your home, but continue to wear a well-fitting mask when around others at home and in public until “,TEXT([Date of first exposure]+10),”.
•If you are unable to get a test by “,TEXT([Date of first exposure]+5),”, you can leave your home after “,TEXT([Date of first exposure]+5),” if you have been without COVID-19 symptoms. Wear a well-fitting mask until “,TEXT([Date of first exposure]+10),” when around others at home and in public.
•Avoid people who are immunocompromised or at high risk for severe disease, and nursing homes and other high-risk settings, at least until after “,TEXT([Date of first exposure]+10),”.
•If possible, stay away from people you live with, especially people who are at higher risk for getting very sick from COVID-19, as well as others outside your home until “,TEXT([Date of first exposure]+10),”.
•If you are unable to quarantine, you should wear a well-fitting mask until “,TEXT([Date of first exposure]+10),” when around others at home and in public.
•If you are unable to wear a mask when around others, you should continue to quarantine until “,TEXT([Date of first exposure]+10),”. Avoid people who are immunocompromised or at high risk for severe disease, and nursing homes and other high-risk settings, at least until after “,TEXT([Date of first exposure]+10),”.
•Do not travel during your 5-day quarantine period (after “,TEXT([Date of first exposure]+5),”). Get tested at least by “,TEXT([Date of first exposure]+5),” and make sure your test result is negative and you remain without symptoms before traveling. If you don’t get tested, delay travel until “,TEXT([Date of first exposure]+10),”. If you must travel before “,TEXT([Date of first exposure]+10),”, wear a well-fitting mask when you are around others until “,TEXT([Date of first exposure]+10),”. If you are unable to wear a mask, you should not travel until after “,TEXT([Date of first exposure]+10),”.
•Do not go to places where you are unable to wear a mask, such as restaurants and some gyms, and avoid eating around others at home and at work until after “,TEXT([Date of first exposure]+10),”.
•After quarantine, watch for symptoms until “,TEXT([Date of first exposure]+10),”. If you have symptoms, isolate immediately, get tested and notify us of the results."),
[Stage]=6,
CONCATENATE("
Employee Guidance:
•You should stay home and isolate from others until “,TEXT([Date of onset of symptoms]+5),” and you must be fever-free for 24 hours without the use of fever-reducing medication and your other symptoms have improved (Loss of taste and smell may persist for weeks or months after recovery and need not delay the end of isolation)
•You should wear a mask when around others at home and in public until “,TEXT([Date of onset of symptoms]+10),”. If you are unable to wear a mask when around others, you should continue to isolate until “,TEXT([Date of onset of symptoms]+10),”. Avoid people who are immunocompromised or at high risk for severe disease and nursing homes and other high-risk settings until “,TEXT([Date of onset of symptoms]+10),”.
•Monitor your symptoms. If you have an emergency warning sign (including trouble breathing), seek emergency medical care immediately.
•Stay in a separate room from other household members, if possible.
•Use a separate bathroom, if possible.
•Take steps to improve ventilation at home, if possible.
•Avoid contact with other members of the household and pets.
•Don’t share personal household items, like cups, towels, and utensils.
•Do not travel during your isolation period. After you end isolation, avoid travel until “,TEXT([Date of onset of symptoms]+10),”. If you must travel during “,TEXT([Date of onset of symptoms]+6),” to “,TEXT([Date of onset of symptoms]+10),”, wear a well-fitting mask when you are around others for the entire duration of travel. If you are unable to wear a mask, you should not travel during your isolation period.
•Do not go to places where you are unable to wear a mask, such as restaurants and some gyms, and avoid eating around others at home and at work until after “,TEXT([Date of onset of symptoms]+10),”.
•If you have access to a test and want to test, the best approach is to use an antigen test towards the end of the 5-day isolation period (“,TEXT([Date of onset of symptoms]+5),”). Collect the test sample only if you are fever-free for 24 hours without the use of fever-reducing medication and your other symptoms have improved (loss of taste and smell may persist for weeks or months after recovery and need not delay the end of isolation). If your test result is positive, you should continue to isolate until “,TEXT([Date of onset of symptoms]+10),”. If your test result is negative, you can end isolation, but continue to wear a well-fitting mask around others at home and in public until “,TEXT([Date of onset of symptoms]+10),”. Follow additional recommendations for masking and restricting travel as described above.”),
[Stage]=7,
CONCATENATE("
Employee Guidance:
•“If you test positive for COVID-19 and never develop symptoms, isolate until “,TEXT([Isolation date]),”.
•You should continue to wear a well-fitting mask around others at home and in public until “,TEXT([COVID Test Date]+10),”. If you are unable to wear a mask when around others, you should continue to isolate until “,TEXT([COVID Test Date]+10),”. Avoid people who are immunocompromised or at high risk for severe disease, and nursing homes and other high-risk settings, at least until after “,TEXT([COVID Test Date]+10),”.
•If you develop symptoms after testing positive you should let our nurse know. She will then follow the recommendations for ending isolation for people who had COVID-19 with symptoms.
•Do not travel until after you end isolation. If you must travel during “,TEXT([COVID Test Date]+6),” to “,TEXT([COVID Test Date]+10),”, wear a well-fitting mask when you are around others for the entire duration of travel. If you are unable to wear a mask, you should not travel during until after “,TEXT([COVID Test Date]+10),”.
•Do not go to places where you are unable to wear a mask, such as restaurants and some gyms, and avoid eating around others at home and at work until after “,TEXT([COVID Test Date]+10),”.
•If you have access to a test and want to test again, the best approach is to use an antigen test nearest to “,TEXT([COVID Test Date]+5),”. If your test result is positive, you should continue to isolate until “,TEXT([COVID Test Date]+10),”. If your test result is negative, you can end isolation, but continue to wear a well-fitting mask around others at home and in public until “,TEXT([COVID Test Date]+10),”. Follow additional recommendations for masking and restricting travel described above.")
)