-
Dashboard - Data source - not showing recently added reports
There is an issue with reports not showing up in the Data source list in the chart widget but I still do not see my new report showing up in the list when I searched for it I don't see my new reports)
-
column symbol to change given certain criteria in a helper column AND if an attachment is not attach
Hello Smartsheet Community! I want my column symbol to change given certain criteria in a helper column AND if an attachment is not attached to the row. Example: For projects valued at greater than 250k Euro, I want my user to attach a project plan to the row in the sheet. I was hoping to have a "symbol" column that would…
-
Count Multiple Cells Formula Question
Hi! I am not sure I am doing this right, I am second guessing myself. I am referencing another sheet and this if the formula I am using: =COUNTIFS({PM1}, "Yes", {Date}, MONTH({Date} = $[Month#]@row)) + COUNTIFS({PM22}, "No", {Date}, MONTH({Date} = $[Month#]@row)) + COUNTIFS({PM3}, "No", {Date}, MONTH({Date} =…
-
"if and" and greater than or equal to
Can anyone help me figure out why this formula is returning an #invalid operation result? It seems to get angry whenever I put the "=" into the "less than or equals" part of the and functions... =IF([TOTAL Risk score]@row <= 20, 0, IF(AND([TOTAL Risk score]@row > 20, [TOTAL Risk score]@row <= 50), 0.25, IF(AND([TOTAL Risk…
-
plot multivalue drop down menu (non numerical) vs months
Hello, I have a sheet where we track patient complications I have columns with the Event Date (when the complication occurred), Date created, and a column with a multiple choice drop down - where as many as applicable can be selected. They are numbers but just words. I need to be able to create a report that shows a bar…
-
How to use SUMIFS
Hi Community! I need to track the hours I spend on different tasks in a week. Then, I need to sum the column "hours" if "date" is inside a specific period of time and if "done" is checked. I tried the following formula, what should I correct? Thank you so much! =SUMIFS(hours1:hours4, Date1:Date4, {Date Range}>= DATE(2023,…
-
Is creating an equipment level training tracker like this possible?
I'm working on a project for Employee Equipment Level Training tracking. I am new to this role and new to Smartsheet. After some researching, I think the Employee Onboarding template (Setup: New Employee Onboarding - Smartsheet.com) is a great idea, however it doesn't meet the needs I’m looking to cover. I’ve also looked…
-
COUNTIFS with HAS two words/phrases in same cell
Hi! I am trying to write a formula to count ONLY when the cell in the description column has BOTH "eat" AND "scale". I want to use HAS because sometimes I want to search for an acronym and I think it is counting other combinations of letters when I use CONTAINS. If the description @ cell has both phrases, I want a 1 to…
-
Countifs by year and month with nested countifs for other values
I am trying to count up survey responses by month and year on another sheet. I took this in bite size pieces so this first formula is the whole formula currently working on. =(COUNTIFS({Survey Range 2},YEAR{Survey Range 2}=2020,MONTH{Survey Range 2}=9),((COUNTIFS({Product}, "Buildings", {Survey Range 1}, "4-Meets Needs"))…
-
Compare two column dates, if over 7 days, list in a third column no
Good afternoon, I am wanting to take the date of column 1, compare it to the date in column 2 and if the comparison reveals more than 7 days has elapsed to mark column 3 with the word "no". Additionally, if less than 7 days has elapsed to mark column 3 with the word "yes". I've searched these forms and have found similar…