-
Question about Formula
I am working on a request form, I had a link to an inventory sheet. Is there a way I could have the requested value turn a specific color if it is greater than the inventory value.? Also is there a way I could link a whole column to one cell in another sheet without having to individually do each cell?
-
Decreasing a set number when a name appears
Hello! I am trying to create a formula for assignments where I can set a number (3), and when a name appears in a sheet, that number decreases for each time the name appears. I also currently have a formula where I have the number of times a name appears / 5 (we have 5 days of the week displayed each week so while the…
-
Creating a tailored drop down list in a column based on the value in another column.
Example - Risk Log. I want to be able to create dynamic filtering of a dropdown column "Sub-Category" based on the value selected in the Name/Number "Category" column. I've seen this done in Excel using the combination of: Excel Functions: INDIRECT() – to reference a named range dynamically SUBSTITUTE() – (if needed) to…
-
Automatically populate a new row in a report that contains formula references to a master sheet
Hi, I am struggling to find a solution to something that should be straightforward, I think. I want to create a dashboard that plots (1) summary values from a master sheet extracted every 2 weeks. Alternatively, I thought I could plot these values from a helper sheet that contains the same formula with a cross-reference to…
-
Question: I’m trying to create a formula in Smartsheet with multiple conditions
Question: I’m trying to create a formula in Smartsheet for a Date column ("Shipping Deadline") based on multiple conditions: If the "Column B" cell already has a date, keep that value as an answer to this cell. If not then If the "Column A" cell is blank, leave the result blank. If not then If the "Column C" is either…
-
Formula to show Row #
I want to include a column that includes the sheet row # for each line that can be included in a report. The formula I've found is =row(), yet when I enter it in the sheet, I get an unparseable error. What am I missing? Thanks
-
Pulling Date From Cross Reference Sheet
Hi there, I have a column full of dates from the source sheet, which I want to populate a column in main sheet if the date is within the next 30 days. Based on that date from the source sheet, if it is within the next 30 days, I want it to pull the cell in the same row in a different column. I have this so far but it's…
-
Can Someone Share a Working WBS Formula?
I'm having issues with WBS formlas. I have 3 columns: RowID Level, and WBS I pulled formulas from a Smartsheet template online (from a forum) but it's not working properly. The first row is the Project Title The second row starts Phase 0 - Project Initiation — it starts with 1, Numbering structure is 1, 1.1, 1.2, etc.…
-
Finding Duplicates
Tried using the "find duplicates formula" that are posted in the community, everyone seems to be working, for some strange reason mine is not, wonder why…
-
Can formulas be copied over to another sheet by the automation workflows?
Here's the scenario: I have a scoring template that I intend to use for different site locations to gauge their several programs and their current state. This template has formulas imbedded to calculate scoring for each program. So let's say Sites A, B, & C all complete their template, and these sites are part of Division…