-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
-
Formula IF OR CONTAINS - Change State to State Abbreviation
I have a State Column and a State Abbreviation Column. The State column is a dropdown column that is filled out from a Form. I have a Formula in the State Abbreviation Column that looks at the State Column and then populates the appropriate State Abbreviation. Here is my issue for West Virgina and Arkansas it populates…
-
Systems and Services subscription renewal dates
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…
-
Change Status Based on Previous Row
I am trying to create a column formula that will change the status of a row to "Ready for Work" when status in the row above it changes to "Complete" I tried to follow the information that was provided this thread, but I keep getting #UNPARSEABLE: I already have an auto-number column (Job # - font is just in white based on…
-
What formula will return one of three date fields based on set critera?
Okay, so here's another one for the community We have a tracker with three date fields. The PM Received date #1 should take priority and be returned if not blank, otherwise, we want one of the other two dates, whichever is not blank. (and only one of #2 & #3 will be not blank) PM Received Intake Date: The actual date…
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Cross Sheet Reference Maximums
Hello! Does anyone know if cross sheet reference maximums increased since Engage? I know sheet capacity increased and cell link capacity increased, but I don't recall cross sheet references specifically being called out. As far as I am aware (and is still documented: Smartsheet Help Page), there is a maximum of 100 cross…
-
Index/Match with Has and Specific Select
I have an master roster and each week I need to ensure a response for each. Since each responder has mutliple areas of responsibility, one submission may cover multiple items from the master roster. I used an index/match formula however when there are multiple entries in a single line, I get a #No Match. And now that the…
