Im trying to develop an equipment maintenance app from a google spreadsheet. I have constant input value for service intervals that differentiate for each piece of equipment. in another column i have a yes or no.
When i generate the data in app sheets it tells me the formulas are read only for the yes or no column. I tried doing it as an app formula but it is not using the constant that i have in my spreadsheet. Im a bit confused on this.
In addition, I want to show all services due (multiples at once in the app)
Any advice is welcome thank you
LinkedIn
Twitter
