-
#BOOLEAN Expected Duplicate Month checkbox formula assistance
Formula I am using =COUNTIFS({F & A Monthly Updates Range 2}, Department@row, {F & A Monthly Updates Range 3}, "3"). The problem I am facing is when submissions are made multiple times for a duplicative month. For example, the form has a system column to capture the date the submission on the sheet form was made. If I…
-
Count "Red" symbols in Sheet Summary
Hi all, New to Smartsheet and wondering how I get my sheet summary to count the number of "Red" symbols for status reporting. Understand that COUNTIF won't count symbols from what I have read. Does anyone have a way around this? Thanks in advance.
-
How can I make my calendar reflect the color of a data selection?
Hi! I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different…
-
Trying to use SUMIF to add columns a crossed a row
Below is the formula I am using =SUMIF([Committed Or Projected]@row:[Committed Or Projected]@row, "Projected", [Jan-23]@row:[Dec-23]@row) The error message I am getting is #incorrect Argument set. I am basically trying to add a row range if a value is set in another column. Can Sumif only be used on columns,s not Rows?
-
Formula for [date]+1 month?
Hi all, If I was using excel, I'd use: '=DATE(YEAR($A1),MONTH($A1)+1,DAY($A1)) However the equivalent smartsheet formula... '=DATE(YEAR([Column2]12), MONTH([Column2]12) + 1, DAY([Column2]12)) ...doesn't seem to be very "smart" at all, because it gets to December and can't handle the concept of rolling over into the next…
-
Networkdays between a date and today
=NETWORKDAYS([date to vendor]1, [today], [holidays]) Help! I need to calculate the number of days since a date and today excluding holidays. Thank you!
-
COUNTIF pointed at multiple contacts in a cell
I'm trying to count the number of times a name appears in a column that is configured for contacts and is set to allow multiple contacts. So using the Countif function, I can easily count up the number of times "John Doe" appears in a column...UNLESS....there's a cell that contains "John Doe" and "Jane Doe". The Countif…
-
Date formula to return end of following year
I am trying to calculate a new date which returns the end of the year following one year from a date. So for instance, the date entered is 3/4/2022, I need to return 12/31/2023. I have tried the IFERROR formulas but keep getting an error. Thank you!
-
Automated workflow (email alerts) stopped working
I have a number of automated workflows set up to send alert emails that are no longer working. They were previously working fine for days (and I tested them repeatedly), but they have all of a sudden stopped. I haven't changed the automation and the sheet is locked, so no one else could have either. Is anyone else…
-
Formula help PLEASE! Three fold IF formula
Hi This is not working for me hoping someone can help me please? This fr =IF(NOT(CONTAINS("Fit", Description@row)), (OR(IF(AND(Description@row = "To Aim spraypainters", [Install/Pickup date]@row < TODAY()), [Install/Pickup date]@row), IF(CONTAINS("Install", Description@row), (VLOOKUP([Job Number]@row, {Factory QC Signoff…