-
Auto fill cell value if adjacent cell matches cell in another sheet.
Hello, I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on my main RFI Log. my main log: 1st column is RFI #, and 2nd column is internal…
-
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.…
-
COUNTIFS and Date Range
Hi I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count. For this count I want to filter on current date date from a range in a column (Current Due Date). e.g. date range 30/04/2019 to 30/04/2020 =COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2,…
-
VLOOKUP selectively returning the information into sheet
Good day I have been working on a couple of sheets where I gather the information with the help of a VLOOKUP. I originally worked with about 10 stock items to get all the formula work done, and everything worked perfectly. I have added all the stock items which now adds up to 494 line items. In the example below, you can…
-
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…
-
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…
-
Bringing back values from another sheet
Hi all, Is is possible to bring back all the values from a column in a different smartsheet to a sheet I'm working on without "looking up a value" like you would i.e. using a vlookup formula? Thanks, Carlos
-
RYGG balls based off of the date
Hi there! I am working to automate the RYGG balls and its like I can get parts of the formula to work separately but not all together. I added a Past Due column to use to try to refer to that indicator to get the formula to be a little less complicated. The goal is: If Due Date is blank =then no balls or "" If the Due Date…
-
IF AND with Date
Hello, I am trying to achieve the following: If the date is grater than 2020,6,30 and the salespersonA is "D" and salespersonB is "T" then calculate 30% of net profit, otherwise leave the cell blank. What I have so far is below and I have an error "#unparseabl" =IF(AND(Date2676 > 2020, 6, 30, [SalespersonA]2676 =…
-
COUNTIFS + OR
Each quarter completed jobs get moved to a Completed Sheet for that relevant quarter. However, some of the tasks done on that job needs to be reported for a previous quarter. An example of a task would be a Preflight Review, which takes place at the onset of a job, meaning the job is very likely to complete in a following…