-
SUMIF the amount in one column has the correct pipeline status in another column
Can someone please help me with SUMIF, I am losing my mind and keep getting errors. I have a pipeline document with status' ( approved, declined, awaiting client, in progress,etc) and I need to show in a dashboard the sum associated with each item. PIPELINE STATUS | dropdown with status' AMOUNT APPROVED | the dollar…
-
IF Statement Check box, not returning check
Hello, I have a sheet that I am saying if a score is over 80 to check the box. The formula itself seems to be working as it is returning the 1 however I want it to check the box not show me the value. Any ideas what I'm missing here?
-
Formula with multiple IF criteria
Hi all - Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past. Below is what I have tried and I am receiving an "Unparseable" error. =IF(Stage2<>"Complete" AND [Due Date]<= TODAY, 1) I am not sure that I am combining the two statesments correctly. Can anyone…
-
Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at the…
-
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…
