-
Workflow has become invalid
Two workflows recently became invalid after working smoothly for months. No permission changes were made to the destination sheet and the sheet has not been deleted. But I get this error message. Even if I try to recreate the workflow, the destination sheet does not appear as an option anymore. I have tried everything.…
-
Help with unparseable COUNTIFS
Here is the current unparseable formula which isn't working; any help is much appreciated: =COUNTIFS([CATEGORY]:[ CATEGORY], "Criterion1", [[TOPIC]:[ TOPIC], "Criterion2"])
-
If Cell A1 equals "X" then call out the Cell A2, if Cell A1 equals "Y", then call out the Cell A3
Hi, Just wondering if there is any formula i can use If Cell A1 equals "X" in the Sheet B, then call out the Cell A2 in the Shhet B, if Cell A1 equals "Y" in the Sheet B, then call out the Cell A3 in the sheet B Sheet B Column A1 = X Column A2 = $45 Column A3 = $30 Result with the formula = $45 If I change the column A1 to…
-
Managing different Holidays calendars
Hi, In my schedule, I would like to manage different holidays calendars associated to different department. In this example, I have 2 Departments to manage : "Dept1" and "Dept2" I have created a specific "Holidays" sheet to manage the different holidays for each departement with a date column called 'Dept1' to list all of…
-
Need help with =SUMIF in summary report
I'm trying to get a sum of time spent for week ending date 7/31/20. This formula gives me a total of zero. Any suggestions for what I'm doing wrong? I've tried the date with and without " ". Thanks! =SUMIF([Week Ending Date]:[Week Ending Date], ="07/31/20", [Time Spent]:[Time Spent])
-
Form is not populating to Smartsheet - Help!
Hi there, Created a Form and tested successfully last week, data entered into Form after submission populated properly to Smartsheet. This week, 'live', form info when submitted is not (making it to) populating data to Smartsheet. Any idea why this is happening? Thanks!
-
How to search a row for a date among blank values?
I am trying to create a nested IF(ISDATE())... function to pull the date from the columns right of the first column. However, when I try this, after the first IF(ISDATE()) function I am get error message "#UNPARSEABLE." I am unsure of why this is happening. I have tried retyping it multiple times, but am still getting the…
-
Does anyone know why the COUNTIFS function used with a DATE range stops counting things done at 7PM?
I am currently using this function: =COUNTIFS({Closed}, <=DATE(2020, 4, 30), {Closed}, >=DATE(2020, 4, 1)) to calculate the number of projects closed every month. When I compare the number that is calculated to the number of rows in the sheet that it is referenced, it doesn't match because everything that was closed after…
-
SUM(IFERROR(INDEX(COLLECT(MATCH))))
I may have just the brackets wrong or overthinking this but I need to return the SUM of column 'eOEM' when the 'Date of report' column is in the next 7 days AND the 'transaction status' column is "New". The formula I have is =SUM(IFERROR(INDEX(eOEM:eOEM, COLLECT(MATCH("New", [Transaction Status]:[Transaction Status],…
-
What is wrong with my COUNTIF formula?
I am not sure what is wrong with my very simple formula... =COUNTIF(Quarter:Quarter, "Q1") I have a list of 700 line items and am trying to add formula to total up a count of programs 'by quarter' in sheet summary and keep getting #imparseable or #invalid data type (if I add "quotes" outside Q1) I am creating a new field…
