-
Formula to Change Symbols in Column Depending on Review Status
Hi all! I'm working on adding a formula to a column to populate status symbols in another column. I've attached an image of the sheet for clarity - I would like to display the symbols in the 'Director Approval Status' column, with the original dropdown selections listed in the 'Director Approval' column. Here is the…
-
Form Filler
It would be cool if instead of going from form to sheet it could go from sheet to form. I send out a lot of paperwork that if I could just populate with the info from certain columns, it would save me a lot of time or at least give me a fairly complete first draft of the paperwork I need to send out.
-
Smartsheet not saving consistently
I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time when I return to a given Smartsheet, data I added or changed is missing, did not take. This doesn't happen…
-
Can IF(INDEX(MATCH())) return true for multiple rows?
I'm trying to develop a formula for the Booked column that will return true if the value in Date/Time is found in another sheet. That much I can do, but my problem is that the timeslots are 4 hours long so I need it to return true for the three following rows as well. For example, if the first timeslot (9:00-1:00) in the…
-
Sorting Rows
My team and I are adding rows to a sheet. I want to be able to sort the rows of information based on the date the rows were added. As a result, I sorted the rows according to the date they were created and saved the sheet. As each of my team members adds new rows, the rows are reordered. How can I keep this from happening?…
-
PMT calc
Is there a similar function to PMT? =PMT(rate, period, pv, fv) etc? Have not been able to find one. Thank you.
-
Change Cell Workflow across sheets
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another. My scenario: I use a date/time based automation to copy pertinent cells from one of my…
-
Extract multiple pieces of a text string that meet a criteria - between parentheses
I want to extract both the 1234 and 4567 from this text string: "First set of data to extract between parentheses (1234) and second set of data to extract between parentheses (4567) and that is it" I am able to pull the 1234 with this formula: =IFERROR(MID([TEXT_COLUMN]@row, FIND("(", [TEXT_COLUMN]@row) + 1, FIND(")",…
-
I am looking to use an Index match to concatenate a persons roles
I have a sheet to track workers roles however, some people are listed multiple times as they have multiple roles because depending on the project their role is different. I was wondering if there was a way to use an Index(match( to either concat all of their roles in 1 formula without the use of a helper column. My current…
-
Automatically disconnect sheets from Resource Management when deleted
Could you develop a fix that makes sheets automatically disconnect from Resource Management when they’re deleted—either initially or when they are permanently deleted after 30-days. It’s quite annoying to hunt down a deleted sheet—because you have to know the owner—and when it’s permanently deleted, you see that there’s no…