-
Linking Sheets - Asset Management
Good morning, Hoping someone can help me out. I have searched the community boards and cannot seem to find an answer! I currently have a form that users submit to request a repair on a piece of equipment. The requests then go to the Cold Equipment sheet or Hot Equipment sheet based on equipment type (refrigerator, steamer,…
-
Check Box count rolling 30 days
Hi all. I'm looking to count the number of Marketing opportunities indicated by a check box on a rolling 30 days, formula below #unparseable. =COUNTIFs([Marketing]:[Marketing], 1), >=TODAY(-30), [Date of Order:]:[Date of Order:], <=TODAY())) Regards
-
Smartsheet Forms - Auto Populate other fields via a pre-defined list?
Smartsheet Guru's If a field is populated within a form, i.e name, can Smartsheet then auto-populate other fields via a pre-defined list? E.G. If name is Joe Bloggs, the location field populates as London. Answers on a postcard and all help is appreciated! Woody
-
Incorrect values in linked cells - days count values ("PT1944H" and such)
Hello, I wonder if anyone of you dear SmartSheets Users, came up with a problem of some random (?) values popping up in cells that are linked from another sheet, in particular to pull through the project duration (in days)? Out of a sudden we started getting "PT1944H" and "PT2088H" in some cells, where we normally should…
-
Year Support Contracts - Automation to update end date
We use the following formula to populate the end date of a one year contract. Namely if it starts the 1st Oct 2022 the contract expires on the 30th Sept 2023. This formula works for every other day in the month except when the renewal falls on the 1st ? =IFERROR(DATE(YEAR([Support Contract Start Date]@row) + 1,…
-
Way to spread budget cost across quarters/years?
Hi Community, I have a row of projects and I am tracking budget cost, duration (months), expected start date and expected end date for each project. I want to divide the budget cost evenly for each quarter where the project is expected to be running. I have a sheet with quarters/years as columns and one row with the budget…
-
Clear cell automation still not working?
I have a really simple automation in my sheet. When a dropdown changes to a certain value a number of cells on the same row should be cleared. I cannot get this to work at all. I noticed there were some serious problems with the clear cell automation earlers this year, but is it still not working or what? Please see…
-
Join-Collect or Index/collect formula with original number format 0.00
Hello, I am looking for assistance with returning a string of data in the original number format (i.e. 0.00) used in the source sheet. I am using the JOIN-COLLECT formula. I get that it converts the results to a text format. I have seen suggestions in other posts to use INDEX/COLLECT to hold a date format, but I can't…
-
Average % Complete calculation
HI all, I need advice on the % average calculation at parent level.I’m finding a discrepancy in the average % indicated at parent level. Here is the case, I’m finding a discrepancy in the average % indicated at parent level. Here in the column % Complete, the Row 877-Test0 is having two indents Test 1 with 50% and Test 2…
-
Can you create a column formula for auto-number generation that will recognize ancestor relationship
I have a sheet that I would like to custom create an auto-number formula so a record ID is given when a new record is submitted, but I also also want it to be able to recognize descendant rows and give them the same Record ID as the ancestor row (instead of generating a new record ID for every new row). Below is an example…