-
=[Sheet Column]@row = "" not working (from Date type)
So I have a Last Updated column that is a Date type, then I created a temp column just to test this where I apply the formula [Last Updated]@row + "" to a cell in temp and i just get the same value I have in Last Updated. I've tried changing the column type for temp to both Date and Text/Number
-
Calculate Health for all tiers of a project based on hierarchy, Status, Dates, Percentage Complete
I have a project with the following hierarchy: I would like the Project Name health to calculate based on the average the Project Stage Health I would like the Project Stage health to calculate based on the average the Milestone Health I would like the Milestone health to calculate based on the average the Task Item Health…
-
Countifs Parent rown
I have a countifs formula =COUNTIFS({DO VSD Workstream Action Plan Range 4}, $WorkStream@row, {DO VSD Workstream Action Plan Range 1}, "Complete", {DO VSD Workstream Action Plan Range 2}, 0) But in front of the first criteria I only want to count the rows with same parent row I've tried =COUNTIFS(Parent({DO VSD Workstream…
-
Recurring date workflow help
Hi, I have a sheet that has task, start and end dates, and assigned person (as well as a few other columns). I also have a 'recurring date' column. This sheet contains tasks that are done twice a year. I would love to set up a workflow to alert the 'assigned to' person 2 weeks before the start date. But I also want to…
-
Issues with Importing and/or Copy/Pasting in Numbers
Hello. I am having a bit of a challenge with bringing numbers into smartsheet, and its an issue that isn't constant across all of my sheets which is what has me stumped. I need to copy/past in numbers each week to (2) different sheets from (2) different excel sources. When I copy/paste in from excel sheet #1, the numbers…
-
How to count when you have multiple crteria in 2 different columns you are trying to capture?
=COUNTIFS("[Interested Volunteer Role]12:[Interested Volunteer Role]85, "Vaccinator (Clinical)", [Interested Volunteer Role]14:[Interested Volunteer Role]82, "Dunkin Donuts Park-Hartford, CT 11/14/21 (Dose 1); 10am-4pm") So for example if they chose they want to be a Vaccinator (Clinical) but can only help on one date…
-
Copying Automation Not Working
I am trying to set up an automation to copy the row to "90-day Reviews" whenever a new row is added. Can someone please help me figure out why the rows are not copying? The sheet that I am trying to copy to has the exact same rows as the master sheet with the exception that the master sheet has the first two rows hidden as…
-
Want to do an IF/AND but not skilled enough to make it work
=COUNTIFS([Proposed Finished Year]1:[Proposed Finished Year]22, 2022, [Strategic Initiative]1:[Strategic Initiative]22, "Revenue Growth") COUNTIFS({Sheet - Project Requests Range 2}, Primary35) Trying to tie the two formulas together to count each initiative (there are 5) in rows and only for 2022.
-
Can you do a Countif on a column that has a "Dropdown multi-select"
=COUNTIF([Date/Venue of Interest]8:[Date/Venue of Interest]93, "Dunkin Donuts Park-Hartford, CT 11/14/21 (Dose 1);10am-4pm") The colum has the following options to choose from for multi-select & I want to be able to count how many people are selecting for each date & time slot if that makes sense. Dunkin Donuts…
-
How do I get a formula to understand that 10 is 10 and not 1? It is not factoring in the zero.
I have this formula in a calc sheet for reference: =COUNTIFS({Month}, HAS(@cell, "10"), {Contact Method}, "Booking Appointment") The “10” is meant to look for dates that start with 10 for the month and this formula has worked for 1-9 months, but now for October it is pulling January because it’s only looking for “1”. How…
