-
How to add date condition to IF/AND equation
I have multiple IF/AND equations in a column formula. I want to add a condition to the IF/AND equations to apply before a certain date in a column(Date of Shoot). This is an example of one of the formulas: IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16), 250 But is shows as…
-
Sheet Summary field to sum a column if a box is checked
I am trying to create a sheet summary field that will sum a cost column for any line that has a check box checked, but I can't figure out the formula for it.
-
Formula : Date & Time Column
Can anyone assist me with a formula to show Column 1 - Column 2 = Column 3? Sounds easy enough but the Date/Time column is throwing me off. This is an existing sheet so they don't want me to change the formatting on Column 1 or 2 if possible. Column 1 : Created Date (Date & Time) Column 2 : Modification Date (Date & Time)…
-
Join two columns
I have a column for first name and one for last name that I would like to join together in a column called combined name. This is what I tried and it doesn't work: =JOIN([First Name]@row, [Last Name]@row])
-
Question regarding equation output if cell value is negative
Hello all. In a budget tracking sheet I created, I have a row titled "Remaining" that subtracts monthly input spending from the original "Bid" column. In the case that a value in the "Remaining" column is negative (over budget) I would like this number to be subtracted from a contingency row I have in my bid column where…
-
Nested IF's with blank cells.
Good afternoon Community! I'm working on a formula that will Assign a "New" or "Old" Cost center based on a date field. I have this functioning properly using the following formula: =IF([Transaction Date]@row < DATE(2023, 3, 31), "Old - Cost Center", "New - Cost Center") Now, I am trying to add in a feature that will leave…
-
Bring back value based on a value in another cell
hello all, I have a formula that brings back a list of names in another sheet if in the current sheet cells with the respective column names are "Yes". Originally, I wanted to bring back column headers and since it is not possible in Smartsheet, I created a helper sheet reflected the names in the order I want and then in…
-
How do I return the oldest date from one column based on criteria from another?
I have been trying to use the min(collect) formula to return the oldest date if another column has Yes in it. =MIN(COLLECT({New Daily Reports to Process Range 1}, {New Daily Reports to Process Range 1}, {New Daily Reports to Process Range 4} = "Yes"), TODAY()) I am referencing below and if there is a "yes" in the column I…
-
SUMIF hours worked week by week, if a project is being worked on in that week.
Hi y'all. I have a project tracker I have built. We are looking to sumif a column if that project is being worked on in that week. Project rows have a date and end date and hours per week worked on. The issue I am running into is when a project has a 1 day phase or when a project has a start date/end date that falls…
-
IF Statements with Multiple "Truths"
I am trying to build a nested IF statement that uses OR to look for multiple true options, but am getting an "Unparseable" error... any suggestions? =IF(OR([ENG Risk]@row="Red", [ENG Risk]@row="Yellow"),"Risk", IF(OR([SC Risk]@row="Red", [SC Risk]@row="Yellow"),"Risk", IF(OR([$$$ Risk]@row="Red", [$$$ Risk]@row="Yellow"),…