-
Automated Workflows Not Quite There
Hi I wanted to use automation to help update fields in a sheet and that does not work. If I update a field for example When field "With" changes to "Cierr" change the complete column to "Star" This does not work. I have to create a calculation in the cell to reference this. It would be much easier to add automation for the…
-
Date Dependency
Hi, Our ERP system exports tasks and the materials needed for those tasks with the same task ID number. We schedule based on the actual task and predicted duration. Is there a way to automatically assign the same start date to the materials needed for the tasks based on the scheduling of the actual task? Screenshot…
-
hiding columns or data for certain users
I'd like to add budget data to a project sheet but hide that info from certain users. Is this possible? And is it possible to have the sum of amounts in sub-tasks appear in the cell of the main task?
-
Nested COUNTIF formula
Hi! I am hoping someone can help me solve this formula. What I am trying to do is keep a running total of hours of vacation used. For example, If Joe wants to take an 8 hour vacation he will go to the dates and type in "V8" (Vacation, 8 hours) or 4 hours would be "V4".ETC. When this is entered I want those hours to be…
-
Most Recent Date
Hi everyone... I've been struggling with how to do the right formula here and would love if anyone could help. I have a form which people are to fill out twice a month to do a temperature check on their progress. The data will have the date, name, etc., then their "mood" (a dropdown list), and each entry will be a separate…
-
finding items past due
This is a formula to find out how many tasks Jane Doe hasn't marked complete in the last 7 days. It's not producing the correct number when I run it by a filter on the original dataset. Any insights on how to make it more simplified? COUNTIFS({Project List Range 3}, FIND("Jane Doe", @cell) > 0, {Project List Range 4},…
-
How to force a sheet to fully recalculate via the API
Hi there API Developer community, I wish to use the API to force a sheet to recalculate. Currently, we use a report that shows just the first row of every one of our 50 or so project sheets and then we manually copy a new value into a column on that report that we have put aside for the purpose. So, once a value like…
-
COUNTIFS formula using dates excluding weekend days
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends. For instance, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
help with formula
Hello, I'm still quite new with sheets and I wonder someone can help me out with this formula I'm currently struggling with. What I want to do is to check/compare email addresses. The following works well when adding formula to a check-box type cell comparing whether the [Modified by] entry is the same like [Email] entry.…
-
IF Planned Date is Still blank leave RGB Status Column Blank
Hi, If you could please assist with the formula below? The formula works perfect, except for when no date is entered in the Planned start date. Currently when no date is entered in the Planned start column the RGB ball stays "Red", and i would like it to show "". Current formula: =IF([Kick-Off Meeting Actual Finish]1 <>…