-
If then Formula help
Hello! Looking for help with my formula that would enter the text "complete" if the checkbox column was checked and if the checkbox column was not checked it would subtract the due date from today's date to get days remaining. Here is my attempt at a formula - thank you for the help! =if([Data Received]@row, 1 =…
-
Help with a Formula?
Hi, I am working on row of dates and I am trying to get the next due date (from today) in another column. I have tried a couple of formulas but get #UNPARSEABLE. What should the formula be? I am looking for the formula for the cell in yellow.
-
Formula Help - Works in Progress Based on Start and End Dates
Hello, I am working on a resourcing sheet to look at works in progress by the week. I have a sheet that has a column for each week of the year. I am working on a formula to reference another sheet which has a list of projects with the Project Manager and start and end dates. For each week of the project (the start week,…
-
Formula Help Needed...
Looking at the chart below I've identified the number of times a Agronomist name appears in a row from a master sheet. For example, Wayde Looker appears in 3 different row items, Ron Beyer 1, and Jason Sanders appears 14 times. How would I pull at a row level (by person), the status of each row to complete the chart? The…
-
Sumif and Approval between 2 sheets
Hi Everyone, Formulas are for sure not my greatest skillset :) looking for some advice on the formula for a calculation only if Approval for the request has been approved. It's a simple time bank for overtime where the Supervisor /Manager can see if the person is in the plus/minus with overtime. 2 sheets Time Bank Employee…
-
IF Statement based on multi-value drop-down
Hello All, I have an IF statement that needs to execute a formula if True, and present a statement if False, typical I know. But I need this to work based on the multiple values that can be selected in an adjacent cell. I've tried IF CONTAINS or IF HAS and have not had success. Let me know if anyone has encountered this…
-
Formula / Solution / Idea - If cell exceeds a value move remainer to another cell..
Greetings….. Need a formula or solution that if the value of a cell exceeds 10, move the remaining to a different cell. In this example, I have columns named C1, C2, C3, C4 and Time, and a form that collects the data from the Time field. A user goes to the form, they add 15 into the Time field, I would like 10 placed in C1…
-
I need to calculate the estimated end date of a project based on working days
To calculate the end date of my project, I need a formula that would take today's date and add the number of working days left to it. I keep getting an Invalid data type error. The Today's Date column and my Estimated project finish date column are both set as Date column types. My Days Left column has it's own formula…
-
Calculating a review date based on both the hire date and last date of review
So I've burned up about 6 weekends working on this, and have asked a few peripheral questions on it, but never just asked the whole thing. I met with a Smartsheet pro and he suggested I bring this to the community. I would really appreciate some help on this. I need a formula that will calculate the next review date…
-
Formula is not pulling back valid contacts
I have a formula that is collecting contacts from another sheet via Join & Collect. The source sheet column is of type Contact List as well as the target column. The target column has allow multiple contacts per cell enabled and restrict to list values only disabled. I've tried comma, new line return, colon, semi-colon…