I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated!
1) This checklist will need to be filled out each clean.
Is there any formula to post(return) the name of the logged in user?
I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODAY(), "")can we have something like =IF(Closed1 = 1, Logged
I am pulling multiple reports into a dashboard. I am then making charts from these reports. One of the reports, will not measure the same as the others even though the criteria is the same. For example, the bottom % are showing 1% multiple times along the lower horizontal of the page. I want it to
I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder.
I understand that we could copy the formula/function body as text to a hidden column for
I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly.
Any assistance you
I have a complicated request. I want to create a formula that will provide a % when a row is designated as a "critical path" item. See screenshot. As a box is checked in the column for each cabin name, I want to get the % to update for those critical checked boxes.
Is there a way to do this? I
Hi all -
I would like to calculate if something is due this week based on a target date in another cell.
I have tried this formula: =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes")
This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for.
Hello community -
I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me.
Is there a way
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum