-
Formula Help... I think I need SumIf, And
Hi! I have this table below. Basically, I need it to sum the approved budgets for any project that is not assigned to someone, AND is not ready for a final inspection. Thanks for any help!
-
How do I create dashboards for each of my department heads to see the tasks of their team?
I want to create 1 dashboard for each of my department heads to see all of their teams tasks across multiple sheets. (One for Finance, One for Implementation, One for Account management)
-
Formula to Join Cells that have Content (with Line Break)
Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In my example, when I use CHAR(10). It joins the cells, but leaves blank lines if nothing was filled in for a cell. Im…
-
Email Notification : How to Remove the "Personal Email" on the "Changes made by" details
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
-
Multi Select Column to Show as Individual Rows in Calendar App
Hi! I'm trying to build a calendar for speakers assigned to a program. I really want to see a column of individual names and each program they're assigned to in a multi month view. The underlying sheet has the speakers in a multi-select column. The issue is when I have more than one speaker assigned to a program/row,…
-
Cell links not working when sheet is closed
I have multiple solutions that generate time/date-based workflows. When the reminders are sent out in the morning when a sheet is closed, the cell reference in the workflow message does not populate. These have been in place for over a year and were working up until a couple weeks ago, no changes to the main reference…
-
Formula =COUNTIFS ... to not include certain text
ok almighty people..... I currently have =COUNTIFS({Depots1}, [Column1]23, {Product1}, FIND("Other", @cell) > 0) This counts cells that depot is = column 1 row 23, if the product column contains the word Other (product column a multiple select cell, with free type option) However I want to count cells that depot is =…
-
Course Delivery Date formula
I have a formula that seems simple, but for some reason it's calculating an extra day. There are three columns and the first is duration in days, the next is delivery date, then the third is the end date. What should be happening is the delivery date should be counted as one day, then the calculations should be added to…
-
COUNTIF functions returning 0
I am trying to create a countif formula that references one other sheet. I want it to pull with 2 different criteria if the column = 01 and the second column = "open". =COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, "01", {Dump: OPEN AND CLOSED REQS Range 2}, "Open"). This function returns 0 when I know there is a few that…
-
How can we have a drop down in Dashboard
Hi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. Thanks