-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Formula to flag red with multiple criteria
Hi. My name is Frank. I have been working on this formula for quite a while now including requests to Smartsheet support. The formula is to raise a red flag when the end date is less than 3 days away with specific status options. I finally got it working the way I want with 1 exception. It does not automatically account…
-
Help with a formula (match? index? vlookup? if/then?)
Hello! I am looking for help in building a formula for a sheet. I create semester reports on a sub-group of persons that we track in a master database. Because this database is extensive (multiple years) but my reports are created from scratch a few times a year, the easiest way to create mine is to pull the IDs of the…
-
Trying to calculate week start using countif but the calculation seems to be wrong
I'm trying to calculate count of dates using the formula CountIF([date]:[date],"11/25/2019") Wherever i have the date as 11/25/2019, it should give me the count, it should give me the total count. But the formula isn't giving any data using this formula
-
Problem in taking the weekof as Wednesday
I want Wednesday as the weekof based on the date for e.g. If cell A has date of 25th Nov, the weekof in cell B for that date should be 20th Nov If cell A has date of 27th Nov, the weekof in cell B for that should be 27th Nov If cell A has date of 26th Nov, the weekof in cell B for that should be 20th Nov What would be the…
-
Smartsheet IF(AND Issue. Will not work across two separate months
Hi, I've been using Smartsheet for around 6 months and would class myself as intermediate. However when it comes to Formula's I'm certainly a novice! I have a Smartsheet that acts as a Hotel rooming list. Users can load their Hotel Check In Date and Check Out date which then prompts a formula to count up the nights that a…
-
Index / Match Multiple columns from another sheet
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the team information. When I add a name to the new sheet, I assign that name to a team.…
-
Return Most Recent Date and Other Column Value or Only Flow Most Recent Entry into Sheet per Account
I need to be able to return the most recent value for the Created Date column and the corresponding Discussed column text. Currently, I am using an IF, COUNT, MAX, CHILDREN formula that I found on the community to return a MAX date within a grouping of rows but I can't figure out how to also return the Discussed value that…
-
How to handle a very long list of (multiple select) choices in a form
I am new to Smartsheet and using it to replace old InfoPath forms. One thing I cannot find an elegant solution for is expanding fields/sections. Basically, I want to send an instructor a form that asks which courses they would like to teach next semester. There are hundreds of courses. I will eventually want to use this to…
-
Extracting string from a cell
hi all, would love some help here for this-- I have a column that contain these strings in a cell: "relates to ABC-25277, relates to AF-4329" "is caused by ABC-33334, relates to ABC-33362, relates to AF-10303" I want to extract the "ABC-25277" from the cells and populate into a new column.