-
IF Formula with Multiple Choice
Hello! I want to build an IF formula into columns when the multiple boxes has selected the right department. IF the Authorizer is marketing and finance, the emails would automatically populate in marketing and finance column. Not sure if this can be done. Would appreciate your help greatly!! Thank you very much.
-
How to list values in a cell based on another cell with distinct names (in a list format too)
Hi, We are trying to present the labor hours workers have dedicated to one same task on different instances. We started by nesting =JOIN(DISTINCT(COLLECT({Worker}, {Task}, "DC6-" + [Task Label]@row), ", "), ", ") We have successfully filtered a list of workers that have dedicated hours to a task. We would then want to…
-
Robust Sheet Summary Feature would be cool!
I would love it if Smartsheet had a more robust sheet summary, rather than creating those using formulas on the grid, or creating a dashboard to pull in those summaries/formulas from numerous grids. The sheet summary on the right menu often doesn't capture all that you would like and give limited flexibility in capturing…
-
How can I calculate the average NETDAYS between 2 columns?
I want to calculate the average NETDAYS between these two columns as a field in my sheet summary. How can I accomplish this?
-
SUMIFS and referencing columns on another sheet
I've been searching the community and couldn't find an answer so hoping someone will see this and help.. I have a data sheet and am creating a calc sheet for a report. I want to look at the reference sheet, identify one "type" and then sum all the $ for that one type. I have tried different SUMIF/SUMIFS and I cannot figure…
-
Trying to get a dashboard to update with the most current entry.
I am building a weight loss dashboard for a client, that they can use for their clients. Everything is working how I want it to except for the current weight. I am trying to get that to update based off of the most current weigh-in weight that is added via the form. In the picture below it should be 180. I am trying a…
-
Sheet Summary Won't Count # of Cells with %
Hello, I have a sheet that has a column for % complete and I cannot get the formula in my sheet summary to count the # of cells that are 25%, 50%, 75% or 100% complete. The formula I'm using is =COUNTIF(Percent:Percent, "25"). This seems to work to count any that are 0% but none of the other numbers. What am I doing wrong?
-
Calculating a Total Occurring within a Specific Month (SUMIF)
Hello, I am working off the provided personal car mileage tracker to create a monthly total for an employee. I am creating a sheet summary formula. My formula isn't giving me an error but it isn't calculating either! I've tried it with and without the parent/child indentation and same result. I want to calculate the total…
-
Count Column if cell does not contain
I am working on a sheet summary formula. The column in question has a formula that will indicate a task is complete based on other criteria. I am trying to calculate the number of rows that are not reading "Complete" in the summary. The formula for that column will return a numerical value for other rows, based on how many…
-
Date validation formula referencing Sheet Summary fields
Hello, I'm trying to update a date validation formula to include a reference to two Sheet Summary fields. The formula seems to be working -- except for the piece that references these Sheet Summary fields (in bold): =IF(OR([Preferred Date*]@row = "09/04/23", [Preferred Date*]@row = "11/23/23", [Preferred Date*]@row =…