-
"Iterative" Formulas or Loops
Hello everyone. I am having an issue where I do not see a way to make any of my formulas iterate any specified number of times, let's say similarly to a "for" loop in a programming language. I am curious if there is a solution I am overlooking or if this is not currently doable with Smartsheet. Please see my example below,…
-
Changing WEEKNUM formula to pull on Sunday's instead of Monday's?
Hello, I have a sheet that acts as a "day tracker." Each row is a new date that tracks specific data in each column. I have a "Week Number" column attached to the "date" column, however the week number populated does not match the week number shown in Outlook calendar and Excel. I think this is because Smartsheets starts…
-
Formula to change status symbol if a task is not completed before due date
Thanks guys, new to Smartsheet and need some help... Having issues with changing the status symbol to Red, Yellow, Green, or Gray based on project completion percentage column (%Complete) and start/due date columns ("Start Date" / "End Date"). I would like the following: Gray - If %Complete equals to 0 and start date has…
-
Cross sheet Formula
What formula should I use to populate column E in "GHG Electricity" adding monthly total (Columns E to P) from cross sheet "SPI Data" for each site (in Column A) with Electricity (in Column C) ? THANKS!!
-
Nesting IF statements with the FIND function
Hello all, I am having an issue nesting an IF statement I created for a specific type of sheet. Lets say we have a column named Full Name and it has values in it like "This Long Name - A new value" The original function would be something like: =IF(find("This Long Name",[Full Name]@row)=1, "TLN"+MID([Full Name]@row,…
-
Combine Multiple Form Fields into one column
We are using a form to enter new customer information into a smartsheet file. Our key is a formula setup with multiple columns combined to create the unique key, since some of our customers work for the same company out of the same office location and we need to be able to search by all. Is there anyway to combine in the…
-
Improving Formula Descriptions
I feel like it could be better shown, for a variety of examples, how formulas can be used. For example, this image doesn't really tell you what the answer to the example is. The example only shows that those data types can be used but doesn't help you understand what it does. Minor gripe I suppose. Also sometimes I wonder…
-
How to catch duplicate data using formulas or premium apps?
Hi, Good day! I need help in catching this duplicate data with the same Service Type and Last Name but the First Name is different because the first one has middle initial. Can this be caught by sort of using formula or premium apps like datamesh? Anyone have a great mind or idea how to make a new column and formulas then…
-
Timestamp - Record Date & Time in a Field
Hi there, I want to set up a workflow with multiple approval steps and record e.g. when each step was approved; is there a way to push the 'current' date and time - as a fixed value, not as =TODAY() - into a cell ? The modified date/time only catches the last modification of the whole line, so that's not going to work for…
-
Who could use a PARSE function?
So I have been trying to think of how to best word it, and trying to help someone else with a solution led me down the rabbit hole I needed. How about a PARSE function. =PARSE(range, selection number, delimiter) Use case would be plentiful, but a couple of examples would be... A. You want to search a range for the second…