-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Pull reference data from another sheet while filtering out based on a multi-select dropdown
Hello, I'm new to Smartsheet and I'm having a bit of trouble with referencing data from one sheet to another. I think this question has been asked multiple times, but I'm confused on the format of the formula's as this is a complex problem. I want to have a master 'Parts List' which is a complete list of parts with some…
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…
-
Showing a minimum amount if 2 things arent met help
Im trying to get a daily minimum field where if the sum of certain cells dont reach a specified amount then its that amount, but if it does it subtracts it until it gets to 0, right now it's giving me -numbers. also i only want to do this on parent/child rows that have a date field populated already. i then want to…
-
If Statement
Hi Team, Can anyone help me how to write this condition In Smartsheet Thanks
-
Countifs formula for counting the number of specific returns from a Multi Select Column
Hi Everyone, I am trying to add some metrics to a Dashboard and one of the Metrics i am trying to count is the number of times an option is chosen in a multi select column. The formula i have tried so far is =COUNTIFS({Oracle EMT 21 Key Element of Works}, CONTAINS("Mechanical"), {Oracle EMT 21 Date of Enquiry}, >=$[Start…
-
Create formula to calculate network days in blank cells
I need to create a formula that will track aging up to and including the day files are processed by an analyst. Once the “Date file received” column is populated with a date, the formula should count the weekday(s) up to and including “Date Processed” date. For example, if the date file received date is 4/22 and the date…
-
Another automate RYG balls for parent based on child
Hi, I have a project plan with multiple levels of children. Currently, the RYG automation is as follows: =IF(Status@row = "Done", "Gray", IF([Due Date]@row > TODAY(+7), "Green", IF(AND([Due Date]@row >= TODAY(+3), [Due Date]@row < TODAY(+7)), "Yellow", IF([Due Date]@row < TODAY(+3), "Red")))) What I want to do is create a…
-
COUNTIF or COUNTIFS formula for a date column, criteria based off MONTH and YEAR
I am trying to total the number of completed submissions on my Ankeny Repair spreadsheet based off of a specific month from a specific year. Range 4 is the column with the completed dates. My current formula is this... =COUNTIFS(MONTH({Ankeny Repair Range 4} = 1) AND (YEAR({Ankeny Repair Range 4}, =2020))) The error…
-
Automation send alert to secondary email
Hello, When setting an automation to send an alert about new fields added to a spreadsheet, the alert arrives to primary email address even though it was set to be sent to the user's secondary address. How can I ensure the alerts arrive into the user's secondary email address only and not appear in their primary address?…
