-
Check Box if B/O Qty is > 0 OR Status column says "Backorder"
Hello, I have been messing with this formula forever and I feel like I am just barely missing the mark, but cannot seem to figure it out nonetheless. GOAL: If column: "B/O Quantity" = 0 check the box, OR IF column: "Status" says "Backorder" check the box. If both instances occur still check the box. Okay, the formula I…
-
Invalid Reference issue
I have a sheet where I am pulling data from 3 different sheets into. After a while (eg. if im coming back on to smartsheet) #Invalid ref error appears in all my cells. How do i resolve this without having to edit the formula and relinking the sheets?
-
average formula is not working to calculate total retention and total turnover
First row is retention rate and second row is turnover and it keeps giving me an error. Below is the formula i am using for average this is the formula i used to get turnover percentage: But every time I put the average I get an error. Can somebody please help.
-
Search criteria in multiple sheets
I have created a Master Project sheet for three (3) different teams' projects (Team A, B, C). Common fields (columns) include "Project ID", "Project Manager", "Project Category" and "Target End Date". I now need to search the Project ID in all three (3) teams' sheets, matching the ID entered in a fourth (4th) Master…
-
Update data in one sheet from another sheet that updates daily?
Hi there, I have separate product sheets (70 of them!) for each product a division creates. Each row in the sheets has a unique line item number. The first 23 columns contain data pulled from one of our systems, including the line item number. The remaining 26-40 columns contain data that's managed manually. I have another…
-
Creating a formula to show status based on time of input date
Hello all, I am trying to create a formula. I need the status of a field to change color to indicate when its time to perform a task, which is based off of the input date and would change two weeks after. For example, if the task was done 08/14/23, that date would be added manually to the row and the status in the row…
-
How to combine these?
Need the formula to say: If Completed - Green If Canceled - Gray If In Progress - Yellow If Not Started - Red If On Hold - Yellow If In Progress, Not Started, or On Hold and and today is greater than End@row - Red Here is what I have.... Works fine. Now need to add in the last bullet and I'm stumped. =IF(Status@row =…
-
Is it possible to URL-Query an embedded form?
I am wondering if it is possible to prefill an embedded form on a dashboard by referencing the form in the dashboard URL?
-
Automatically change Parent status to display Children status; still be able to change Child value
Hello, I have this formula =IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(AND(COUNTIF(CHILDREN(), "Completed") = COUNT(CHILDREN()), COUNTIF(CHILDREN(), "") = 0), "Completed", IF(OR(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), COUNTIF(CHILDREN(), "Not Started") + COUNTIF(CHILDREN(), "") =…
-
Index Collect Formula for Dates resulting in Invalid Value Error
Good afternoon, I am trying to use an Index Collect formula to collect dates that have dependencies. Here is the formula I'm using: =INDEX(COLLECT({Portfolio Summary | Actual Start}, {Portfolio Summary | Project Number}, [Project Number]@row), 1) + "" I can confirm that the formula cell is a date column, as well as the…