-
Formula for last rolling three months for each service listed
Hi all, Ive deep dived into finding this formula and while it seems to be working, its only counting "0" which is inaccurate. This is a calculation sheet pulling from master tracking sheet. I want it to count the number of rows for each service in the last rolling three months. Thank you in advance!
-
Help adding to formula to include Satruday/Sunday dates change to preceding Friday
I currently have a formula for a 'due date' column that looks at another date column "DOD" and calculates if the status is 'probability' for that row it makes the 'due date' column "DOD" + 5 years, otherwise the 'due date' column is 8 months + 1 day from the "DOD" date column, adjusting for the next year if the 8 months +…
-
Populate Data from Sheet Into Form
Hello I am trying to populate data from the sheet the form is connected to back into the form. We only need one person to approve the change order. On the sheet when the Job name is selected from a dropdown menu it pulls in all the data from our master sheet such as name, email, job address, ect into the sheet. (via index…
-
Sum and average
Hello, I would like some help. I have tried this formula in many different ways. I have a master sheet that contains entries as a date, added a column to extract the year. Each entry could be located in two locations. I also have the length of stay of each base on the dates (entry date and exit date as well as a running…
-
Mass Remove Hyperlinks
Is there a quick way to mass remove hyperlinks within specific columns on a Smartsheet? I do not want to "clear content", just remove the hyperlinks.
-
Cross Reference
I am seeking assistance with a cross-sheet formula. Specifically, I am referencing a sheet titled "Visit Notes" and need to calculate the total occurrences of the phrase "Clinical Trial Took Kit" within a row labeled "Visit Notes | Resources Utilized." Additionally, I would like this count to be conditional on the…
-
Alphabetize Using Formula
Is there a way to easily alphabetize a list using a formula in smartsheet? In Excel, I would use the simple formula shown below to assign a numerical value to each unique list item. =COUNTIF([Unsorted Range],"<="&[Specific Cell Value]) This formula doesn't work in smartsheet, so I'm trying to find a solution. I am working…
-
Formula for rolling up children status to parent rows
Hello, I am trying to simply roll-up my children status' to their parent row. When using this formula: =IF(COUNTIFS(CHILDREN(), @cell = "Complete") = COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> "")), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress")) I receive…
-
CountIF & Parent Child Relationship
Is there a way to have CountIF look at job # and return the number times a job # has been used on a sheet with respect to the Parent and ignore the children with the same job #
-
Adding to a X-Sheet INDEX(MAX(COLLECT( Formula
The original formula I had works: INDEX(MAX(COLLECT({Change Log - ADDRESS Prior DATE}, {Change Log - ADDRESS DATE CHANGE}, 1)), 1, 0) Now I am trying to add an IF statement and am getting an #InvalidOperation error. Can you recommend a change to the formula? I am trying to add an IF statement that looks at a date column…