-
Trouble with long date formula
Hi, I am working on something that will tell staff when the open window for a visit is, based on the visit category. Rule 1: Visits in the category of 1, 2, 3-5, 6-10, and 11+ years should be annually and the window is their DOB +/- 1 month. This portion of the formula works. Rule 2: 3rd trimester visit should start 197…
-
How to split the content of one cell into separate columns
I have a cell with data in this format: Approved,AAD:tammy.couch@transcoretech.com , 9/3/2019 11:06:50 AM I already have a formula for the Status Column, which is Approved. That formula is =IFERROR(LEFT([MFG Approval (archived)]@row, FIND(",", [MFG Approval (archived)]@row) - 1), ""). It works great. However, I need to…
-
VLOOKUP formula pulling data from another sheet
I'm using the VLOOKUP Formula to match the "Application" in table 1 to "Application Name" in table 2, then return the "Primary Product Family" from Table 2, Column 2 to "Program" in Table 1 where the formula is. =VLOOKUP(Application@row, {Applications}, 2, false) What I'm I doing wrong?
-
Change dot color based on date field
I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month. The symbol column is already set up with the right column type. Thank you for the help!
-
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
-
Percentages lost when indenting linked cells aka best way for roll up smartsheet
Hello I am trying to connect about 50 project plan sheets on one sheet. The requested configuration is a traffic indicator for a customer then the ability to drill down to see each customer project and status then a drill down for high-level milestones. FYI I have just read about the limitations so I understand eventually…
-
How can I bring cell values from one sheet into another sheet "multiple values cell"?
Below is the source sheet destination sheet
-
Calculating a review date based on both the hire date and last date of review
So I've burned up about 6 weekends working on this, and have asked a few peripheral questions on it, but never just asked the whole thing. I met with a Smartsheet pro and he suggested I bring this to the community. I would really appreciate some help on this. I need a formula that will calculate the next review date…
-
Since Smartsheet Gov has no sheet summary, where do I put formulas?
I have a sheet I want to move over to the gov version, and when I went to do that I noticed there is no sheet summary. My sheet has hundreds of formulas and it would be useless with out them. Any suggestions on where to put them? Do I make another column called sheet summary?
-
Access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…