-
Calculate date based on review type and date of last review.
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 365 days to 'Date of Last Review'. If 'Review Type' is '90 day review', add 90 days to 'Date of Last Review'.
-
Count the number or non-blank cells in the specific ranges for 2 groups of rows
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" and "Canada") In this case I need to count only the non-blank cells if the value in the column named "queue (RE and Canada)"…
-
Clean-up formula
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. By doing so, I was able to run formulas to give a numbered response. Is there a way to clean it up?…
-
Copy Start and End Dates (& Predecessors) from another sheet
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 corresponding State Date in the other plan, but it doesn't seem possible. Does anyone have any creative ideas on how to pull this…
-
Automated emails not sending attachtments?
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 it set up to send the information needed and I made sure attachments were checked as well. I also told all the admins "add…
-
Report and Dashboard
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 can I use a half-pie graph to show the number NETDAYS greater than 37 and NETDAYS less than or equal to 37. I do have…
-
Creating Formula to implement 72 hour advance reservation policy
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 using Smartsheet. I've come up with this statement to potentially help with implementing the 72-hour in-advance requirement:…
-
Formula
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 number automatically populates another cell on the same row?
-
Joining two index/match into single multi-contact column
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 I try adding the two formulas under a single column, I no longer see the email contact formatting that I would in the other.…
-
Find / Mid / Len / Right Formula Question
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 Argument erros when I try to put this in. I think it is because some of these text strings are longer than others or other…
