-
Formula - Completed projects in a given year
Hello, The formula pasted below works great if I want to count the number of projects completed in a year. How can I revise the formula so that I can count the number of projects completed in 2020? Thanks!
-
Automating Status of "Completed"
I want to be able to have all tasks with a status of "completed" moved to the bottom of my parent section. I don't want to move to another sheet, but instead to the bottom of the parent. Is there a way to do this? Formula / Automation? Thanks in advance! -mc
-
% complete using checkboxes
Is there a formula or function that will count up the # of children checked off and report the total % checked in the parent row? As an example, I have two out of six activities (children) checked off, which means the parent work package is 33.33% complete. I would like the parent checkbox to report the 33.33% and update…
-
Use of "If-Formulas" in Smartsheet-Salesforce connector
Hi Smartsheet Community, we have the Smartsheet-Salesforce Connector in place and for a new connection we need to us "if-formulas" within the connector settings. Example 1: If a date field is empty in a project in Salesforce, would like to put date 12/31/2999 (and not an empty field) in the corresponding field in…
-
Populating a daily Schedule when there is a range for a task
Hey all - I'm hoping someone can jump in and help us with a formula that will look at all the dates in the range and help us pull the information into another sheet when any of the dates in the range are the lookup. This is our master scheduling sheet which shows a box scheduled for pouring Mar8-Mar17...so 8 production…
-
Populate Dropdown
Is it possible to populate a dropdown field with values from a column in a sheet using a formula? thanks! Adam
-
Formula - Count by Month and Other Criteria
I've been trying to determine a formula I can use on a SEPERATE Sheet that will pull from the sheet in the screenshot a: - Monthly SUM number of items that are In Review, Awaiting Publication, Published/Live, etc. (i.e., the "Status" column in screenshot) so, for February, number of items in review, awaiting publication,…
-
Inconsistent results from COUNT(DISTINCT(COLLECT
Hello, I am using a separate sheet to calculate unique names (employees/visitors) who have visited the respective locations, separated by morning and afternoon sessions. I was using Sheet Summary in the source sheet but the numbers don't refresh by itself for some reasons, hence I have created a "metrics" sheet. The…
-
Formula using OR
Can someone help me I keep getting a error message, I know is has to be the OR function. =COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", OR({Civic 2021 Range 4}, "(Stage 3) 3.2 - WON", {Civic 2021 Range 4}, "(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)
-
Budget Calculation
I am attempting to calculate the expected spend year to date with a formula that references data in a month column where MONTH(TODAY()) - 1. This works, but when the new year started, it reset all of the expected spend year to date back to 0. Is there away to set a formula that won't =IF(Month6 = "12", SUM([Budget…