-
Formula Creation l Conditional Formatting (Automating the Process)
Hi! I am attempting to generate a formula to mimic the one I created using conditional formatting (essentially, I would like to automate the conditional formatting trigger). Here's how I would like the sheet to work. Based on the "Risk Classification" drop down selected, I would like the sheet to pre-fill the "Periodic…
-
Join Collect
Hi i'm trying to find all of the timekeepers that worked for a specific client. Normally I would use Index Match however, there are multiple time keepers that worked for the client and index match only shows one name. For Index match I use the following formula: =INDEX({TimeKeeper}, MATCH([Matter Number]1, {Matter Number},…
-
Trend sheet - saving data after it's captured from another sheet
Hi, how do I save data in a sheet to retain for a trend chart? I have a burndown sheet that I've built a line chart to display on a dashboard. I'm able to get the data, however, due to the Today() function, it will only pull the data on that day and as the day passes, it wipes the data. I've had to go into the sheet on…
-
sum hours from a column, if grandchild row in another column has specific text
So I've been tasked with creating a timesheet for our consultant agency by quarter, so each sheet will cover three months, why it has to be in Smartsheet I'm not sure. Context Each day, employees have three types of projects they can be working on: "Proj1", "Proj2", "Proj3". I need a formula that will add up all the…
-
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…
