-
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!
-
Traffic light formula
Hi, I have a traffic light column in spreadsheet and I have a formula that triggers the colour based on a status column. I am just looking to add a step in that turns the traffic light red if it is not started or in progress and it is past the due date Formula so far =IF(Status210 = "Completed", "Green", IF(Status210 = "In…
-
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…
-
f(x) & Edit Reference do not appear
The help documentation states the following about cell references: “You can edit the name, referenced cell range, and source sheet of the reference.” If using a long formula and selecting the cell containing the formula, the left-most portion of the formula is not visible on the display (i.e., f(x) = AND Edit Reference do…
-
Reporting Using Parent Child Relationships
Hello - I have created a report to display the current user's list of high level milestones. This list is supposed to display any milestone that is blank under parent child relationship. This ensures only high level tasks are displayed. Its seems to work fairly well, but I have encountered one issue. For one of my sheets…
-
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…
-
Countifs formula error
within the same report as my list of projects I'm trying to return a count of projects that are due to start within the current week (day 0 - 7) from "today" then return a count of project for next week from (day 8 - 13) then week 3 (day 14 - 20). here's the formula I came up with but it's not working.…
-
Count time between dates in Weeks/Days
How would I calculate the time between two dates (start and finish) in Weeks and Days "8weeks 4days"
-
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…
-
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…