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,…
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…
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.
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…
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…
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…
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…
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…
I am feeling silly that I can't get this to work. I want to get the % complete of my project based on those with the status of "Complete" divided by all columns that have text in it. =COUNTIF(Status:Status, "Complete") / COUNTIF(Status:Status, ISTEXT(@cell))