-
Auto Number: possible to generate Project IDs in Smartsheet?
Hello. Is it possible to generate Project IDs in Smartsheet ? And can these be done using the Auto-Numbers feature ? I have a master sheet containing a list of all the projects that have been under taken in a specific year. I need to assign Project IDs for each project. Can one generate auto numbers for specific rows ? As…
-
More than 2 logical expressions for OR function?
I'm trying to write an OR function that returns an RYGB ball with 3-4 logical expressions but it keeps giving me an error message. Can it only have 2 logical expressions? Here's my formula (i didn't add the Blue logic yet since I couldn't even get the 3 conditions to work) - =IF(OR((TODAY() - [Due Date]@row) >= 14,…
-
create list based on a word
We have a contractor list that captures our contractors data from a form on our website. Here is the web address if you would like to take a look: https://app.smartsheet.com/b/form/e69cfae30cc14c0ebc35f351bf9129a5 One of the cool features of this list is that it utilizes a multi-select dropdown menu. The challenge is…
-
Formula for Counting RYG by Child Row
Hello - I'm trying to add to a Dashboard. I need to see status by color for each child row. I also need a count by each child row (Admin, CPM, etc.). Help! Thank you.
-
SUMIFS help in Summary with column headers containing special chars
I'm trying to get the below SUMIFS to work but i'm getting #UNPARSEABLE. =SUMIFS(Requested Amount (in Local Currency):Requested Amount (in Local Currency), Budget Owner*:Budget Owner*, "Tom MacKay", Approved:Approved, = 1) The column names contain special characters, is that what is causing the problem? Or do I just have…
-
LOOKUP OR FIND WITH SUMUP COMBINED
Hello, Hope you could help me. On Sheet 1, "Future Column", I would like to find in Sheet 2 all similar names against sheet 1. Ex. In Sheet 1 - BOFA, BOFACBRE, BOFAJLL is on Sheet 2 all in Different rows. I would like to combine and sum up as for Sheet 1 "Future" is equal to 9. SHEET 1 SHEET 2
-
today() function affects last-modified date
We have a last-modified column in one of our sheets. We use it to detect when rows in the sheet have been last modified, driving discussions about the updates. In this sheet, another column displays a "project completion date," which is just a manually entered date indicating the project owner's best guess as to when the…
-
Why do I get #Invalid Data Type error message because a cell is blank
HI, I have a column that uses the formula =WORKDAY([HOP Submit F/C]@row, 5) to give a date by which approval needs to be given for documents that have been submitted. The column [HOP Submit F/C] is a date column which itself uses a formula '=[????? Eqpt Order ACK]@row + 145' to get its own date (the question marks…
-
AVERAGEIF or AVG ??????Why is this not working and how do i get it to work
So i basically want to calculate the average of all completed query. In the picture above there is a formula that calculates how long the task takes. If is not complete it does not have a data and the formula will show the #error above..... this i think is where i am going wrong i just dont know how to change it... Please…
-
IF formula for earliest date
Hi Community, Could anyone please help with this formula syntax? I want to capture what is the earliest date within a date range for a specific role, "Production" in this case. =IF(Role:Role, "Production", COLLECT([Actual Start]:[Actual Start], [Actual Start]:[Actual Start], MIN([Actual Start]:[Actual Start])), "") It…