I am trying to set an automation to alert a contact weekly that there have been changes to certain rows, essentially I want to avoid multiple alerts and just have them sent once a week with all rows that were changed but it is not allowing me and pops up with the error message "Workflow Timing Unavailable". Is this not…
我有两个表我想但我有联系n issue with the second sheet listing the linked cell data. The original sheet has assigned contacts that I want to link to my second sheet but when i create the link, the cell does not populate. I made sure the column formats and contacts lists were identical on both…
I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula: =COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of cells that have a date so my team can track how many animals we have enrolled in a certain project. I want to change this to…
Hello, I am generating a sheet to link to the calendar app and am trying to limit the amount of work needed on the backend. I have a daily check in I want listed in the sheet so that it is visible on the calendar app but want to avoid having to manually select each day for the next 6 months. Is there an automation or…
Not sure if this is a question as much as a looking for inspiration. If you have a system for tracking action items from meetings, let me know what you have put together/found most helpful!
I am trying to create a countif formula to give me a count at the top of my column of how many empty rows in a shelf I have. If certain spaces in the shelf are empty they are labeled in my column as "EMPTY". I have tried this formula: =COUNTIF([Study Number]1:[Study Number]636, = "empty") but am having no luck. Please help!
I work in managing long term, in vivo research studies so keeping track of age is important, I am assuming this is a pretty basic formula but I cannot seem to figure it out. I also want an automatic column that just gives me current age. Please help!
