can we generate barcodes of each equipment and with the help of bar code scanner, can it display the information of it with the the options to update the forms? I know we can update the forms but how …
In a sheet that I created and shared with other users, does every user have access to be able to open/view attachments linked to some rows if the user I shared the sheet with doesn't have access to th…
I have a dropdown columns with several choices and each choice represents % complete. The idea is to get the Circuit % complete for 1st and 2nd circuits columns but also It has ‘N/A” that will not cou…
Here is the formula I am working with: =IF(ISBLANK([Start Date]@row), " ", IF(ISBLANK([Actual Start Date]@row), "Not Started", IF(ISBLANK([Actual End Date]@row), "In Progress", IF([Actual End Date]@ro…
I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is …
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a re…
Hello, I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. "communication"). The cell itself won't be only composed of that word, but will just contain it. My formul…
I completed a gantt chart shown here and as you can see my start date is 09.01.22 and yet the gantt charct shows january february, etc., this is ridiculous and completely ruins my chart and I didn't e…
I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s s…
Hi all, haven't been able to find anything on this by searching so I'm posting. I'm hoping it is a simple fix as the formula seems very simple! I am attempting to calculate accident frequency rates at…