-
Handling URLs
Hi - searched far and wide, tried several things, coming up empty. We have a use case where a long link to somthing is inserted into a Smartsheet field (nor a form, just a grid). Can click ctl-K and make it to a clickable hyperlink. However, it ends there. We cannot index or join or even copy paste that clickable URL into…
-
Metrics sheet, filter the data you pull back
So i have a main data sheet and it has a column called key initiatives. In that sheet, i can filter off of that column. So now what i want to do is create a metric sheet that would only pull data from the source sheet that has the key initiatives box checked for that line item. What formula could be used to accomplish this…
-
Bi-Weekly date formula.
Thank you in advance for any help on this! So, I am using this formula: "=TODAY() + (6 - WEEKDAY(TODAY()))" to show a weekly task that is always do by Friday every week. I like this one because each Sunday it updates to the current week automatically, making so that this task it is attached to shows up on the calendar for…
-
How to list employees based on manager
I have a list of managers and their employees on a data sheet. I then have a template sheet that will be used by the managers to fill in the time spent by each of their employees in a month. I would like to be able to select a manager on the template sheet and have all of their employees populated in the rows below using…
-
Working Days across a Date range
Hello friends! I'm hoping to have a column which automatically populates the number of working days in a given period from a [Start Date] and [Number of Months] columns. e.g. Start Date = 3rd July 2023 Number of Months = 2 Result = 45 days 63 calendar days – 18 days skipped: 9 Saturdays, 9 Sundays Would anyone have a…
-
Using the "Created Date" field in formulas
Hello - I am creating a number of fields in various sheets to calculate lead times. One KPI we want to track is the life cycle of a project. I have added the "Created Date" field to all sheets and have an additional field that populates an Invoiced Date. I want a new field that will calculate the number of days between the…
-
NETWORKDAYS
PROBLEM SOLVED THANK YOU
-
Formula to check if a cell contains "No" or isblank
This is probably so simple but I am struggling with my if and isblank, or maybe I don't need isblank and need just "" empty quotes. The Column title is "Added to CRM" and it can contain Yes, No, Revised or blank. I would like to check a cell and if it contains either the word "No" or is blank return a phrase like "Open".…
-
Formula to say less or more than 30 days
I need a formula that says if the event date is less then 30 days from the date the record was created return the words "less than 30 days" but if its more than 30 days return the words "more than 30 days" This is what I came up with but getting an error. Help? =IF(ISDATE([Event Date]@row), IF(DATEDIFF([Event Date]@row,…
-
Date formula to set cut off period
I am trying to set a date formula to for the following statement; if the [Next Due Date] is <= 27/07/2023 return "Performed" Example: =IF(ISBLANK([Last inspection]@row), "", IF(DATE(2023,7,27)) < [Next Due Date]@row, "Overdue", "Performed"))
