-
Count and Lookup - based
Experts, I need to count the values of each column excluding Today Value. Rest of the Yesterday and Blank values of respective columns like #New Hires, and drop the values in the 2 Yesterday Metrics. It is pretty easy to do a vlookup for Today, but if I need to cumulate the Yesterday and Previous day values. How do i do…
-
Count if Formula to retrieve multiple criteria
Hello Experts, I am looking for a formula to count all of the New Hires from Yesterday/Today column using Previous Days and Yesterday values.
-
Use dependencies to set start and end dates independently
how can i use dependencies to help set both a tasks start AND end date independently (not using duration)? As an example, i would like row 3 start date to be row 2 start + 5 (I can get that by setting predecessor = 2SS+5), but I want row 3 end date to autopopulate with row 4 start date.
-
Batch Sheet Creation from Template
Problem: Current Limitations Manual Repetition: Provisioning a large project (e.g., 50+ distinct team sheets) currently requires manually executing the "Use Template" or "Duplicate Sheet" workflow 50 separate times. Time-Consuming Setup: There is no native bulk-action to instantiate multiple files at once, creating a…
-
VLOOKUP to Gather Monthly Adoption Number based on Country
I am trying to find a way to create a metrics based on our monthly adoption numbers, this is the sheet that im trying to take the data from and then enter into the applicable fields in my metrics I want to take if its Global, and if the month is ex: January, take the Online Adoption Rate total and copy it into my metrics…
-
Pulling Values from referenced sheet cell, where mutliple values exist in the cell.
Using the following formula to pull values from a source sheet, when it matches a cell in my current sheet. =IFERROR(INDEX(COLLECT({eITCR # (Open)}, {eITCR - Open AI}, HAS([InfoCard Number]@row, @cell )), 1), INDEX(COLLECT({eITCR # (Closed)}, {eITCR - Closed AI}, HAS([InfoCard Number]@row, @cell )), 1)) The issue I have is…
-
How can I get this formula to work
Hi, I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to…
-
Need formula help
I'm trying to match info in another sheet and return a date column to the first sheet. I've tried a few things but keep getting errors. In Sheet A each row is a job number. I want to fill in the job completion date from Sheet B. It has many job number rows with different job types. The Job type column is Parent/Child. I'm…
-
Lookup Value and Count based on the input criteria
Hello Team, I am trying to bring a formula to look up a value and bring the corresponding counts. The input sheet will look for the "Date of" column and dynamically generate the Yesterday or Today value based on the formual i have written for "Yesterday/Today" column. There is a person going to enter #New Hires, #Leavers,…
-
Need some formula assistance
Hello! I am usually pretty savvy at figuring out formulas, but I am truly stuck on solving this one. Does anyone know a way to solve for the below situation? I feel like it's doable and likely easier than the way I'm trying to approach it, but cannot get the right combination. Background: Our project plans/schedules have…