-
RYG Status
I've looked through numerous posts and sent an email to Smartsheet but am still on the hunt for the exact answer. (I do have a HelpDesk ticket in.) I'm creating a sheet that will be used to conduct document audits and I need to know when an audit is 1. Previous to due date 2. Due 3. Overdue 4. Completed (This is the one…
-
FILTER
Hi, Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report. I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all…
-
formulas under child rows excluded as auto-number column
I have a master sheet with projects that auto-populate from a form that requestors fill out as needed. I created a column named "Request Number" that is a Auto-Number column type. However, I have in the bottom of the page multiple lines with formulas that I use only for my dashboard and although I have all this formulas as…
-
IF & ISBlank Function
I am trying to test whether or not the score inputted is greater than 80 or less than 80. If the score is greater than 80 , I would like my status column to populate with a string labeled "Passed". If the score is less than 80 I would like my status column to populate with a string labeled "Failed". Heres the issue, I am…
-
Index Match Values Based on Certain Parent Rows
First, awesome community! I've been looking all over for a solution to my problem, but cannot find anything that would translate to my situation. Hopefully I make some sort of sense describing my issue. Brief: I work for a construction company that specializes in high rise construction. For my department, I'm tracking…
-
Cross sheet Formula to pull in column value
Hello, I have a Master Server Inventory sheet with columns such as Server Type, Server Name, Recovery Method, and several other columns with common data that has to be collected for all servers. I need to create a variety of separate sheets with detailed configuration data about each server. I want to reference and pull…
-
Index, Match with Find and Left function
I am trying to get a formula to look up a value with the INDEX / MATCH function and the Search_Value being the numbers up to a "-" dash from the "Type For List" column. The index/match does not seem to like the LEFT or FIND functions Has anyone come across this or has a work around? =INDEX({O_Type}, MATCH((LEFT([Type For…
-
Metric Sheet Calculations for a Dashboard
Evening All, i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. =IFERROR(AVG({Sales Variance}), "") Many thanks, Sarah
-
IF statement with child/parent logic
The Problem: I need to have autonumber as a Unique Identifier for each row. When that row changes due to changing business requirements, I want to create a child row but it should not have a different Unique ID from the parent. It could either have the same Unique ID or no Unique ID, but if I have autonumber turned on then…
-
Row number calculations as part of a formula
Hi there, I'm trying to replace the value of a row number in a formula. I have created a rowID column so each row has a row number in that column. I would like to make calculations from that to replace the row number part of a cell reference with calculated value i.e. =Status123 i want to be =Status(row#+Y) How do I…