-
6 Month Anniversary Formula
Hello Everyone, I am an excel wiz but I realize formula writing is totally different within smartsheet. I need help projecting 6 months in advance date. I used the following formula. =DATE(([Start Date]6) + 1),(([Start Date]6) - 6),([Start Date]6)). Any help would be great!
-
Field Service Management in Smartsheet
Has anyone built a Field Service Management solution in Smartsheet? I need to maintain a database of; store locations technicians, their backup tech and their backup of the backup tech dynamic schedule of availability of said technicians I envision some form of a 'lookup' worksheet where appropriate and relevant data from…
-
How would up update this existing SUMIFS formula to add an additional criteria?
I have a current formula that but we have realized that there is one Team who's numbers are skewing the results and would like to have there totals excluded. =SUMIF([Cast Type]:[Cast Type], "Vendor", Estimate:Estimate) + SUMIF([Cast Type]:[Cast Type], "Contractor-Offshore", Estimate:Estimate) The Additional Column is…
-
IF formula based on other cells
Hi, I am trying to create a few different formulas based on the liaison change request being yes. I would like to #1 capture the current liaison's name in the previous liaison column #2 move the new liaison name to the current liaison column. Is this possible? I am sure I might need a helper column or two but unsure how to…
-
If Formula Help: =IF X symbol and X symbol are X, display X in this column
I'd like to select text in a column based on symbol indicators in a column. For example if they are highly impacted, with a "!" symbol and they are not influential with a (down arrow) symbol, i want to indicate that i should reach out to them weekly. See pic. Please help with how I can set up the formula to do this…
-
Can "@row" be used in the Intake Sheet Summary page calculation?
Hi, Just need a sanity check please. Can @row be used in the Intake Summary page calculation? I assume it won't work because it is a summary. However, [field]x:[field]xx (where x is the first row to consider and xx is the last) works.
-
Is there a work around to capture modified by for a cell instead of the row?
Hi everyone, I’m working with Smartsheet’s Dynamic View and I’m wondering if there’s a way to automatically enter the email of the person updating a specific cell into another cell. I only need the email to be captured when a particular cell is updated, not the entire row. Modified by will not work because that changes any…
-
Index Match returns "#No Match" for Project Manager but works for Project Sponsor
In Metadata, the Formula is basically the same between the two fields but Project Manager is returning #No Match and Project Sponsor works. The references are going to the correct places. Can someone please help me find the discrepancy? Thanks!
-
No Match error with Index Match
Hi, I have a column in sheet A that uses the Index Match function to collect data from different sheets. The formula worked perfectly with two source sheets, but I keep getting the #No Match error when referencing one specific sheet, despite double-checking the search value to ensure it matches exactly what I have in Sheet…
-
IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
