-
SUMIFS - #Invalid Operation - Why?
Hello community, there is a formula problem which troubles me slightly. These formulas work perfectly fine =COUNTIFS({6M_category}, HAS(@cell, [Primary Column]@row), {Time of occurence}, >=[Start Date]#, {Time of occurence}, <[End date]#) & =SUMIF({Impact_to_production_hrs}, >0) BUT this one, does not and returns "#invalid…
-
Update Request from a customer not shared to the sheet
Good evening, I need to somehow send a client an update request so they can upload a PDF and Pictures to a specific row but NOT giving them access to the entire row. I see how to limit which cells I send the request. I have tried setting up a automated request but it would give them access to files that may already be on…
-
Sheet Summary Formula's and Report
I have 26 individual sheets that I want to roll up into a report. Each sheet collects data based on partner name, term(single drop down)and meeting type(single drop down). I have used a separate metrics sheet in past projects, but wanted to use Summary. I have the following Summary Field Properties created on the sheet:…
-
IF Y is blank, and X is not, take Date of X and add 90
i know this is not correct.. but. can someone help me fill in the missing pieces. =IF(ISBLANK([Renewal End Date]@row, [Agreement End Date]7, +90)) my goal is to have the Next Review column produce a date that is 90 days from either the renewal end date (if there is one) or the agreement end date Thank you in advance!🙏
-
IF AND formula help
Hello, How do I use an "IF(AND(" formula to get a count of two conditional columns? I am working on calculating a weekly average and I have a date received column which I broke down by "week number:" and "year" in separate columns. However, I have two separate Smartsheets, one being the current task and the other being the…
-
Novel user - Date formula Hellp
Hello, please help I'm fairly new to smartsheet and am stuck. I would love to have my start and end date automatically populate so I do not have to go and add each date on every line as I currently do, one by one. The start and end dates are the same date (for now). This date is not tied to another column. What this date…
-
How to ID names present in other sheets
I have a column of company names in a new sheet. I'm trying to figure out to write a formula that checks a box if the company name in the new sheet appears in any other sheet within the workspace
-
Conditional Formatting - using an "OR"
I have 5 fields that I want to make sure are filled in "NOT BLANK" for each new row that is added to a project plan. I would like to turn turn the row RED if any of the 5 fields are blank. You can add a second or third condition using "AND" but in this case it would be "OR" "Blank". is this possible?
-
Using working day calendar
I need to add another date column that will be updated with a formula. This is not connected with start and/or finish dates. I would like for this column to use the working day calendar to return a date that is a working day, just like the start/finish dates. Something similar to the below where I want to have a buyoff…
-
Statistical Trending in Smartsheet
Hi All, We previously used minitab to trend control data for laboratory equipment, and while I know Smartsheet wouldn't be able to replicate that level of statistical processing, I want to leverage automations to make this type of data tracking more meaningful in Smartsheet. What I am trying to do is to call out data (by…