- Discrepancy in Filters
Hi there! I have a smartsheet where I am trying to report on numbers by quarter, and then numbers by total year, as well as some other filters. However, the numbers are just NOT adding up. I have tried both by filtering through a report and filtering through the smartsheet itself. E.g. I have run individual reports on Q1,…
- 减法公式
Hi folks, I have a Debt total in a cell on my budget spreadsheet (e.g. 7000); I have a row of payments by month (e.g. 160). I want to subtract each new cell of payment of 160 from the total cell of 7000. I want to visibly see the reduction on the 7000 debt cell when each new month of payment is added. Is there a formula…
- Formatting Rows under Parents
Hi all, Is there a way of creating a formatting rule where if a category from a drop down menu is chosen, that row will move under a parent row? e.g. we are doing a protective workwear smartsheet, we would like to categorise things by type of PPE - 'hand and arm protection', 'face protection', 'skin protection' etc.; once…
- COUNTIF = BOOLEAN EXPECTED
Hi I want my smartsheet to count the number of checked boxes in a specific column. I have formulated: =COUNTIFS([Ceremony/Party]:[Ceremony/Party], 1). However, it is cominh up with "BOOLEAN EXPECTED"?
- Sharing Rows for Editing/Workflows
Hi all, I have a smartsheet which is an 'adverse events register'. When a form is filled out, the person will tick if this adverse event is a 'security', 'estates' or 'health and safety' event. Both the H&S and the Estates teams have smartsheet licenses, and have access to all of the information in the whole sheet. The…
- Calculating days between dates, 'unless'...
Hi folks, I have a date column for 'Suggested Risk Assessment Review', and a date column for 'Planned Review Date'. I need a formula to count the days between these (i.e. how overdue are they), UNLESS the 'done' checkbox is ticked. How do I calculate this? Thanks!
- Dashboard Chart Errors for Other Users
Hi, I have created a dashboard with bar chart widgets - these charts are showing all relevant data for me, but when my colleagues (under their own smartsheet log-ins) open the dashboard, the charts are showing a 'data range cannot be shown' error. How do I make it so that the data can be seen by others with access to this…
- Box checks automatically if criteria is met - formula?
Hi! I'm trying to get a ticket issue checked as 'resolved' when somebody fills out a certain field. How do I get smartsheets to automatically check 'resolved' when "self help recommendation" column is "I have tried this and found a solution". Any help?
- Stop lower row automatically copying colours from row above
I have a ticket tracker template being used at the moment, and every time a new ticket comes through from the form, the new row is formatted like a header (dark infill, bold type etc.) - how do I stop this row from being formatted like a header, and instead having it formatted like a child row should be?
- RAG = Date Range formula?!
Hi, I'm setting up a sheet to keep a track of training and re-training needs. I need the RAG status to change according to the date range, e.g.: Person A | Training Due Within 90 Days of Today | RAG = Yellow Person B | Training Due Anytime Over 90 days from Today | Rag = Green Person C | Training Overdue from today up to…
