-
Formula to show duration days in Months, Weeks, and Days
I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…
-
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…
