-
Can you assign a random value based on a list?
I am trying to automate the task of assigning a person to an assignment. Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new…
-
Count if formula with multiple criteria where a field contains certain text
Hello, I am having trouble writing a formula to count rows. Where row 1 = Yes where row2 does not contain "virtual" or "needed" (these single words are fragments of the selection in the drop-down list). This formula is on one sheet and counting values from a different sheet. I can get this to work in reverse ie count row 1…
-
Automate Risk Flag
I would like to automate the risk flag if the date is on or after the Target Date. I am new to smartsheet. having trouble with this. thank you
-
Setting up automated "Priority" in Project Portfolio
My company is moving to Smartsheet and we would like to have our "Priority" column automatically populate as Strategic, High, Medium, Low, or Not Prioritized depending on criteria in 2 separate columns (Impact and Urgency). If Impact and Urgency = "High", Priority = "Strategic If Impact = "High" and Urgency = "Medium",…
-
Alternative to "TODAY Function"
Hello, Problem: any changes/saves to any line, changes the "modified by/date" to ALL lines. This is annoying as I have no idea who made that change or when, as it constantly shows me.... After much research, it was determined the culprit is the "TODAY" function. therefore, I need to remove this function and replace it with…
-
Complex Lookup Formula - need help with returning the proper values.
I'm working with a sheet that is being uploaded daily with new information via Datashuttle. The sheet is populated with the [Route ID], [Warehouse Code] and then in turn i'm trying to auto populate the [Assigned Planner]. The warehouse code has both the warehouse of pick up (which is where the planner physically sits, so…
-
How to identify row number in a sheet where new rows will be added
I want to create a sequence of 1, 2, 3, etc. in a column, but challenge is new rows will be added in this sheet. So, when a new row is added, the top row must have value of 1, followed by 2, 3, 4 for other rows in the column... wish if there was a formula like ROW(), like we've in excel. Any suggestions how to accomplish…
-
Counting blank cells in a report
I have 23 sheets and need to set up a report that includes count of the number of projects. I summarized the project name column and chose count, however it is counting the line that contains the sheet heading. How do I have it NOT count that row in the report? Thank you,
-
Formula to capture Quarter
Good Day! I am struggling with a formula. I would like the formula to identify the quarter within which the project will be delivered and fill the column Quarter. This information will help our finance department plan revenue. I tried the nested IF function below, and I had the ‘’UNPARSEABLE error message. =IF([Date…
-
Dynamic Date Validation and Computation
Hello! I'm almost embarrassed to post the following because I recognize it as a horribly constructed formula, but I am experimenting. First, let me highlight my use case: I have a sheet (first screen shot) that pulls in Start/End Date, Hrs/week, and Hourly Rate via INDEX formula. I'm attempting to have the sheet…