-
Flag based on % completion relative to end date
Hi guys, I'm trying to create a formula that flags, Green, Yellow, Red, when a specific % is closer to the end date. For example, if I have 95% and end date is 10 days ahead, flag should be green, however, if I have 25% completion and I am in 10 days of reaching the end date, it should be red. I was thinking of also,…
-
SUMIF formula
I am having issues with my Sumif formula--it has always worked fine, but all the sudden is no longer working. I am trying to sum a column based off an identifying number in another column. Some rows have the same identifying number and I want them to be added together. I tried changing the [TaxID]1 to [TaxID]@row, but that…
-
Multiple dates collection on form
We would like to use Smartsheet forms to collect data to plan an event. Some events may be multiple days. Is there a way to do a date range or multiple dates on one form?
-
Approval Requests
Hi I am looking at getting approval requests. The idea being is i'm doing the following: Being given a piece of work Requesting through Multi Select Contact List a group of people to do the work This then triggers the approval request and we save on email traffic into certain inboxe that being said sadly today, it seems as…
-
Previous month
The below formula is picking up the current month's sales SUM total: =SUM(COLLECT({Sales Pipeline Amount}, {Sales Pipeline Sales Stage}, "4 - Closed Won", {Sales Pipeline Level}, "1", {Sales Pipeline Finish}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))) + SUM(COLLECT({Archive…
-
Pull data from one sheet to another. Nothing working.
I am trying to create a column formula which automatically pulls data from a sheet called "Employee Details". I will need to do this with data from several columns but I will focus on the "Employee Name" column here. I have already created a cross sheet reference between both sheets in the Sheet Reference Manager. In both…
-
Return several values via a vlookup
Hello all, is it possible in smarsheet to use a vlookup that would return several values in the same cell. I have a sheet with the list of users and the departments they belong to. I then have a sheet with the tasks of a project with a column that contains the users in charge of a task, each cell allows the addition of one…
-
Invalid value (Problem with RIGHT, SUBSTITUTE and VALUE Formula
Hello, As the picture below shows, I am trying to extract 2 numbers from a cell that displays different formats (paper sizes). I need to set up a calculation with the 2 numbers. That is why I use the LEFT and RIGHT Formula to extract the text and the VALUE formula to change it to number format. I also use the SUBSTITUTE…
-
Smoothing out update lag between metrics sheet and dashboard metrics widgets
I need some help gang... I've created a dashboard to display a snapshot of some relevant customer specific values that are stored across several sheets, but I am having some trouble with lag between form submission and updating values on the metrics sheet that feeds the many metric widgets on the dashboard. Essentially,…
-
RAG Status formula scenario
Hi Smartsheets wizards, Good Evening! I have created a formula that has been working great, however I find that if the actual finish date is missing for any reason the RAG does not change to RED. Here is the formula and the screenshot of the schedule. Kindly advise what I should change to get the RAG to change to red if…