-
Nested IFs and various ranges changing other column cell
Hi team - I have a column called Risk Reduction &/or Opportunity Enablement that has specific numbers in a drop down [1, 2, 3, 5, 8, 13, or 20]. Second column is called Risk Reduction &/or Opportunity Enablement Size and has Small, Medium, Large as drop down options. What I need is if the Risk Reduction &/or Opportunityโฆ
-
Auto Populate an entire column with the value of one cell from another column
I'm trying to populate an entire column with a value from one cell from another column within the same sheet. Is there a way to automate this process. I would like the value that the arrow is pointing to populate the entire column "Project Name". I'm using the column as a helper column in the calendar app as a way to groupโฆ
-
I need to skip blank columns in rows
This is my current formula: =IF(AND([BO1 approval]@row = "Approved", [BO2 approval]@row = "Approved", [BO3 approval]@row = "Approved"), "Approved", IF(OR([BO1 approval]@row = "Denied", [BO2 approval]@row = "Denied", [BO3 approval]@row = "Denied"), "Denied", "Submitted")) How it works: If all approvers hits "Approved"โฆ
-
How to make a calculation return blank
I have a simple IF() calc that I thought would return blank if false, but when I go to make a color rule on if this column is blank it doesn't work. If I copy the output of this calculation is appears to be returning whitespace, but I can't use [field] is equal to {put a space in the text box} in the color rule.โฆ
-
Most Occurring Value Based on Multiple Criteria
Our organization is counting how often we interact with clients weekly and that process is going great. What I want to do is show who contacted the most clients during a particular week. We have a data dump master sheet and a sheet where I consolidate some high level data. With this one I don't even know where to startโฆ
-
% Complete with no projected due date
Hi there ~ Looking for some help on the best way to proceed here. It seems duration and predecessors are not applicable for what I am looking to accomplish. I have a Creation Date, Resolution Date and Days Spent columns along with a % Complete column. I would like to show 100% complete or simply complete when theโฆ
-
Time function
I need to record hours in HH:MM in one of the columns of my sheet is there a time format or formula I can use so that entry format is HH:MM . I will not be tracking time in and time out, just the total time worked, for instance, if John Doe worked 7hrs and 20mins, I want to be able to enter 07:20, is this possible?
-
How to split text to support reporting?
Hi, I am bumping into a design / Smartsheet limitation issue. I use an request inventory sheet to track client change requests. CR are submitted via a form. One of the field helps tracking the category of the CR (business feature grouper). I had to concatenate 2 types of data to workaround the form and the fact that Iโฆ
-
Can the auto-numbering function be set up to utilize new numbering prefix at start of each year?
I created a sheet that uses auto-numbering to assign a number to all submitted forms. I want the numbering to utilize a prefix denoting the year and start over at 0 each year. For example the numbering of the submissions in year 2021 will start with 2021-01 continuing with 2021-02, 2021-03, etc. When the year 2022 isโฆ
-
Counting Specific Selections within Date Range
Hi, I am trying to count how many times a combination is selected within each month. For example, how many times does this combination pop up in the month of March I am currently playing with this formula, but keep getting error messages =COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell,โฆ