-
Combining IF functions to read multiple columns and create a flag
Hi all, I am working with the attached sheet trying to create a few flags to appear when certain information is present. The 3 flag columns are '2 Weeks - No Data', '2 Weeks - No Check Ins', '2 Weeks - No Paired Check Ins' and I have formulas within each reading the 'Check In Type' and 'Last Wk Check In' columns. Below are…
-
Question/Help with IF Statements
Hello, I'm working on a sheet for new employees and I'm trying to build a simple IF statement that will display whether or not the employee started, based on today's date. =IF([Start Date]@row = TODAY, "Yes"), IF([Start Date]@row = >TODAY, "No"))) I must be doing something wrong. Do I need rearrange the formula? I'm trying…
-
Update Formula to Include When New Columns Are Added
I have a sheet that tracks the number of hours by the team on each project. When a new project is created an additional column needs to be created (if anyone knows of a way to have it automatically added when a new project is created from a template that would be amazing) and named with the new project name. Then the Team…
-
Use Conditional formatting to mark cells that contain formulas
Good Afternoon Smartsheet wizards, While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not. Thank you in advance for your help. Cheers, Bill
-
Using INDEX/DISTINCT with OR function spread across multiple ranges
I use the following formula to condense data from source sheet to destination sheet with the "distinct" feature possibly combined with an OR function. Something like =Index(Distinct(OR({FLOWER UID}), Number@row, ({SHAKE UID}), Number@row)) or =Index(Distinct(OR({FLOWER UID}, {SHAKE UID}), Number@row)) Source sheet with two…
-
formulating dates excluding weekends
I have 3 columns with different dates. My goal is to enter 1 date, and have the other 2 dates formulated based off the 1st date. I created a formula to satisfy this need, but I am ending up with some dates falling on weekends, which I cannot have. Is there a way to correct this issue without enabling dependencies and…
-
Alternative to COUNTIF with HAS Formula
I need help, please :) On a support sheet, I have a list of Zip codes and the areas of the city they correspond to. On my main sheet, I have a "Company HQ Address" column, that contains the Zip code, but NOT on its own column, it's listed within the cell containing the full address. When I use "=COUNTIF({Source Sheet Range…
-
IF AND with multiple conditions
I've got a doozie for you all. Luckily, I'm partially there. I want to run a function with the following conditions: If Task = C or GM, and JXDN = US, then return Trademark/Domain General - US If Task = E or ACQ, and JXDN = US, then return Trademark Disputes - US If Task = P, and JXDN = US, then return Trademark…
-
Need formula to pull in names associated with RACI roles.
I have a Project Plan template that I would like my team members to save as new for each client and customize the information. Within the Project Plan, there's a RACI matrix with different roles. Please see below for an example: When a new client is assigned and team members save the project template as new, I'd like to be…
-
Dashboard Metrics - Pulling in Week
Hi everyone - I'm working backwards here but I have a Project Plan that I'd like to derive metrics from in regards to Client Name, Health, Status, and Week. What I'm stuck on is how to capture which week in the Project Plan we're currently in. Is there any sort of automation that I'm not thinking of? I want to show these…
