I have a sheet to track 90 day and annual performance reviews. I would like to create a formula for the 'Date of Next Review' column. I am trying to calculate if 'Review Type' is 'Annual Review', add …
Hi, I'm trying to count 2 ranges of rows (in the RP Opportunities column) where cells are non-blank and also matches with the value of another column (this is a drop down list column with values "RP" …
I am sure that is a much easier way for me to have completed this task, but to explain: I wanted to find the statement between the parentheses and replace that with a number related to the statement. …
Can this be done? I have a project plan, and I want to pull over Start and End dates from another project plan. Predecessors, too. I tried typing a formula in the Start Date cell to link to the corres…
I have a simple automation set up where if Cell 1 has any value in it, It will send out an email to the requestor. Sometimes we have to include attachments but it doesn't always send. I already have i…
In my sheet, I have a column calculating the NETDAYS between two events. This column does not show up if I try to create a Summary Report. It only allows me to create a Row Report. In a dashboard, how…
Hello All, I'm new to Smartsheet and need help creating a formula. We require people to reserve an item 72 hours in advance but haven't quite found out the correct way to implement this policy well us…
I have a sheet that has a supplier number in one cell that is assigned to a supplier in another cell. Can I write a formula so that when the supplier's name is entered in one cell their supplier numbe…
Hello, I currently have two columns that are pulling in from a separate resource that contains multi-contact columns. My hope is to cut down on the separate columns and combine them into one but when …
Good Afternoon All, I feel like I am close but just might need a little assitance to finish this formula. However I am trying to pull the "Month_Year" from these text strings I keep getting "Incorrect…