-
Stock sheet automatic email when stock drops below an amount....
Hi everyone, We're putting together a stock sheet and we want to create notifications so that when a figure in a cell drops below a certain amount an email is automatically sent to the relevant people so they know to re-order. Can anyone help please? Many thanks!
-
Setting up automatic reminder system
Hello community, I have a tricky question here concerning how to send out a reminder automatically based on the following idea. I have a sheet which lists the status of certain rows. Each row has a column that indicates with Green/Yellow/Red/Gray dots (symbols) - these indicate if an item has been fixed, pending, still…
-
Help with formula (IF > AND > THEN)
Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Status" must change to 'Overdue'. Link to sheet is HERE.
-
Project Management, If then Statements
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing team based upon the amount of ROI projected and what they rank. E.G. Gold= anticipated $$$ Silver = $$ and Copper = $ If they…
-
IF/AND Formula with Dates
I get a #UNPARSEABLE error on his formula. [Permit Agency Approved] is a date only column [Permit Agency Approved (F)] is a date only column =IF(AND(ISBLANK([Permit Agency Approved]9)), [Permit Agency Approved (F)]9 < TODAY, "Review","None") What I would like to accomplish is, If the [Permit Agency Approved] column is…
-
BUG: #NO MATCH returned on X-Sheet Ref
I have two sheets, connected to each other via X-Sheet References. I tested this feature extensively when X-Sheet References came out http://ronin-global.com/2018/02/22/smartsheet-secure-your-sheets-with-x-sheet-references/ Today, I got this behavior On Main Sheet, I add a Row. I get a #NO MATCH on the return value. In a…
-
Flagging duplicate registration plates
Hi, this is my first post on the forum. I use smartsheets for work but I have created this account to use the forums. I am attempting to create a formula that will allow me to use conditional formatting when two entries use the same registration plate number. The sheet is set out like this (im unsure if the link at the…
-
Reference Row Number?
I'm building a task management sheet that prioritizes tasks by their order on the sheet. A formula calculates lead time of a task based on its current position in the list. Is there a way to dynamically reference the row number of a task? The easiest way would be a function that references the row number (since those…
-
Dashboard showing status of symbols
Hello community, I apologize if this comes across as trivial, but I am wondering what the optimal solution is to show charts (pie, mostly) showing what percentage of cells in a sheet have the symbol Red Dot / Green Dot / etc. Can I access those symbols directly? Or can I do some sort of IF statement which assigns a value…
-
Complex Formulas requiring a lot of editing
Hello, I need to count the number of projects in a certain status, work type by person. I created this formula and it is working but it requires a lot of editing. =COUNTIFS({Assigned To - BD}, "Charles Kimball", {Implementation Status - BD}, "Pending Kick Off", {Work Type - BD}, "Advanced Billing"). This formula is looking…
