Hello, I'm opening a new discussion since the old version hasn't been responded to in some time. Stacked graphs are for some reason adding cushion on the ends. Is there no way to top these out at a certain number or percentage? In my case, I'd like to stop the percentage at 100%. Can we at least know if this is a priority,…
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…
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…