-
Countif and error question
I have had some issues with a formula and I think I FINALLY figured out what is wrong. I want to count the times a question is answered "No" so I am using this formula: =COUNTIFS({PM22}, "No", {Date}, MONTH({Date} = $[Month#]@row)) I keep getting #invalidoperation and think it is because some of the rows have a blank space…
-
Creating an IF formula based off two columns where it can group the data by a timeline logic
Trying to find a way to automate our sheet by using the IF formula to pull data from two columns [status (i.e Sent, Scheduled) and date column] to build a logic to pull a timeline (i.e today, tomorrow, next week, 2 weeks, done, TBD.) into a new column. This is the formula I've built but isn't working, where did I go wrong?…
-
Getting a NO MATCH when using Index/Match in a formula
This has been working very well on previous sheets. This is a Titration Log and it varies per plant and therefore very tailored to their line and parameters. In the steel business - so you'll see substrate as to what I am matching. I have a column that does the look up and returns "red" if out of spec. The ALUM formula is…
-
Countif requirements are different from cell to cell?
I'm calculating a count per month. The September field calculates correctly using an equal sign and the month to count. However, October requires me to remove the equal sign to calculate the count. The referenced column is the same in both months. Why is this happening and how is it corrected? See below pics:
-
Help with complicated formula
=IF(OR([Phase Start Date]@row > DATE(2023, 2, 28)), [Phase End Date]@row < DATE(2023, 2, 1), 0, IF(AND([Phase Start Date]@row <= DATE(2023, 2, 28), [Phase Start Date]@row >= DATE(2023, 2, 1)), (NETWORKDAYS([Phase Start Date]@row, DATE(2023, 2, 28)) / 5) * [Resources Needed Per Week]@row, IF(AND( [Phase End…
-
Microsoft Project Formula to Smartsheet
Hello, I am using a formula in Microsoft Project to automate status changes based of date percent. I wanted to see if anyone would be able to decipher the MS Project folder to a Smartsheet formula. IIf([Current Date]<[Start],"Early",IIf([Current Date]>[Finish] And [% Work Complete]<100,"Late",IIf([% Work…
-
Time delay in workflow
We have a use case to send an item to a team of reviewers to give them an opportunity to review and comment on an issue and then record their concur/do not concur. Then after some period (say 5 days) send it along to the leadership for approval (even if they haven't finished their review). Is there a way to insert a time…
-
Sheet summary report
Hello, I'm unable to view/select the columns of my grid data to create a quick summary report. I can only see the system columns even after selecting the source sheet. Also tried to verify this by creating some sample test grid data, but still, the columns are not visible. Can anyone assist with this? Thanks in advance!
-
Column Formula to Highlight Rows from the Current Week
I am trying to create a conditional format to highlight rows from the current week (starting Monday), based off the Start Date column. I have found a formula here but it wont let me convert to a Column Formula: =IF(WEEKNUMBER([Start Date]1) = WEEKNUMBER(TODAY()), 1) I added the conditional formatting but it is not working.…
-
Create Forms with multiple data points
Hello, I am trying to create forum to collect different data categories. I want to forum to have the option to collect multiple inputs in the same category without having to create a new form. This is to collect products/outputs by an individual. Right now the individual has to submit multiple forms.