I have a calculation to calculate the number of days between two columns. =IFERROR(NETWORKDAYS([Date Submitted]41, [Go Live Date]41), " ") It works great to return a blank if the customer has not gone live. Then I have formula to calculate the average of the cells. =AVG([Number of Days to Implement]12:[Number of Days to…
I'm testing my workflows that have 2-3 approvers each, and the feedback I am receiving is that the approvers are all receiving 10-20 email notifications for the same request. Does anyone know how this might be happening?
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
I am trying to flag contracts needing renewals. What am I doing wrong? =IF(OR([Contract end date]1 <= Today1 + 1 - 90, 1, 0))
Hi all! 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. That means there needs to…
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 match the others which…
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 already have a formula that…
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. Is it possible to determine…
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
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 to set up a column that…