-
Formula Needed!
Hi! I am needing a formula that will count the number of occurrences month to date of a specific data point. I am working on a dashboard for complaints and I am wanting to have a formula on my master sheet that will calculate the number of regulatory complaints we have received month to date that will update with new…
-
Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date: This formula is unfortunately accounting for weekends as well,…
-
Index and collect most recent text and where not blank based on Max Modified date?
I'm using the following formula to collect the most recent comment from children cells. We are having an issue when a user adds a comment and then deletes it and/or types a new comment within the same cell within the same minute. When this happens, the parent retains the blank cell "comment" or doesn't recognize the new…
-
How to search , and match the couple data from 2 sheets and result show on 3rd sheet
Dear All, I'd like to calculate Total stop time of each machines per day. I have tried to find out the solution for search and match the couple data from 2 sheets and result of the couple data show on the 3rd sheet but I am failed. Anyone please help me, how to match and pick up the correct data as example ? Thank you.
-
URL Query String with Dynamic Data Connected to QR Code?
I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
-
How to send an automation to multiple contacts in another sheet?
Sheet A has a column of email addresses, the quantity of which is always unknown (could be 5 rows today, 10 rows tomorrow) and the content is not always static as people change roles (email x may be changed to email y tomorrow). Sheet B has an automation to request an update when a row is updated. How does Sheet B sent the…
-
In need of human brain to resolve AI formula.
I have a text column that says the following: 09/2022 I would like to turn this into a date for the last day of the month, like this: 09/30/2022 This is what the AI generated formula gave me: =DATE(YEAR(VALUE([Delayed Result Date]@row)), MONTH(VALUE([Delayed Result Date]@row)) + 1, 0) I'm getting a #INVALID VALUE error The…
-
Used in Formula for <unknown sheet>
i see this everywhere. i know its from when i delete projects and such, they will leave this leftover trace/breadcrumb ... but why? And does this impact performance? some cells in some sheets have tons of these, so im just wondering why they dont auto remove themselves or how to easily manage those as opposed to clicking…
-
Can I write a cross-sheet formula that works if one has one and the other has many?
Here is the use case: Smartsheet A: Lists selected clients once per row (includes a column with a unique client ID). I created a drop-down column for each product with yes or no picklist. Smartsheet B: Lists clients on many rows (includes a column with a unique client ID). I developed a formula to enter "Yes" IF the the…