- Hyphens between combined cell data when not blank
Hi, I have the below formula to combine a number of cells together to make a naming convention. I want hyphens between each piece of information but only if the cell is not blank. We only have a Program Code 2 about half the time, I don't want an extra hyphen in there when it's a blank cell. The combined data at the moment…
- CTC hours used by the task and role month-wise and visualize it
Hi, I am trying to figure out how to calculate the CTC hours month wise used by the task and the role seperate. Is there any way to find it using formulas or widgets? Appreciate your help
- Analyse three columns content and produce a representation of request priority
Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a "date created" column, and a column that shows the user/form…
- IF Column Formula with Drop Down options
We are trying to create a formula that will recognize a service line type and auto populate the corresponding division in another column, but only for one unique circumstance. Only our Critical Care service lines also need to be Critical Care region. Below is the formula I tried, but when I make it a column formula,…
- 公式有地位“球”bla改变颜色nk cell
I would like to have the status "ball" color change to red if the column cell is blank and green if the column cell has a date entered in it. PLEASE HELP!!!!!!
- If or Index or Match....not sure what to use
I have a Metrics sheet and a Source sheet. The Source sheet has 2 columns, Area and Status. On the Metrics sheet, for each Area, I want to display that associated Status. This is the Metrics Sheet (The % Complete will be pulled from another Source sheet): This is the Source sheet: I tried: Any ideas?
- How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
- Using Row Comments in a Formula
Hello! I am currently working on a dashboard, and need to populate rows that have comments. Is there a way to do so or is there a formula I can use to indicate if a row has comments? I tried doing an IF statement, but I am not sure what the row comments would be referred to. Any information provided is greatly appreciated!
- First Month's Date Range
Hello, I'm looking to get a response like this: 07/01/23 - 07/31/23. I want to get the previous month's range based on the values in the column (The previous month could potentially have entries dating 9/1/23-9/25/23, for example). I am referencing another sheet's column {REF DATE}. Dates range from 7/1/23 to 8/2/23 at…
- NETWORKDAYS WITH AN IF??
Can anyone help with a formula to track the number of days between 2 separate columns with the IF of stopping the count once a date is populated in one of those columns?
