-
Need help to get the correct percentage formula
Hi smartsheet community, I am facing difficulty in getting the formulas straight to get the right percentages. On the simple formula it is correct but how can i add 2 more of the same parameters? can someone help me please?
-
formula to pull data from a sheet when criteria is met
I've got a sheet for tracking work changes and when they have been approved, I want to set up a formula in a 'helper' sheet to get just the key data of the work change I've set up the below formula, but it only pulls through data from the 1st row - how do i get it to work for all rows? =IFERROR(VLOOKUP("Yes", {Variation &…
-
How do I calculate the sum of a length of time column in the Sheet Summary
I want to be able to calculate the total length of time of all the video files in a sheet for the Sheet Summary. (to then be able to report across multiple sheets, populate in a dashboard etc). These are not formulas and there is also no start or end time as this is the length of a video, not work time. Also, as these are…
-
Order Form - Item Cost Total
Hello Smartsheets Community, I have created a simple order form for our smaller customers to use to submit their orders. Based on the screen shot below, when a dealers chooses the 1961 Totes to order, the individual item numbers will be visible as check boxes. If a dealer clicks on an item number to order, it will open up…
-
Attempting to look for duplicate names in one column that are between dates in another
Essentially I am trying to find out if a name in one column shows up a certain amount of times within a certain range. Essentially being, does "employee name" appear at least 2 times within 1/1/2023 and 1/31/2023. More than the 2 is not an issue, but essentially trying to find out those that are at least twice. I…
-
Adding another parameter to IF(OR) with multiple conditions
I have a formula working exactly how I want it to, unless I add one more parameter (checking a checkbox), in which case I don't even know where to begin. Would that be an IF(AND(OR))? If so, can someone help me with placement? The current formula which pulls from [Docs Check Date Helper], [Cargo Ready Helper], [Latest ETA…
-
How do I update the Parent Cell so that anytime one of the candidates (listed in the Child Cells)...
is marked as "Hired" as the Status, it then doesn't count that row? For reference, see the first Parent Column "Accounting - 3 Openings" - however, there is only 1 opening that doesn't have the status as hired and it's not showing that...I tried to add conditional formatting to change the row to "Green" if status is Hired…
-
How to move an item in Calendar view and ensure it also updates the finish date in Grid view?
Hi Everyone, I'm working on a social media calendar. I have these columns: 1) Copy, 2) Start Date and 3) Finish Date. When I drag and move the post in Calendar view, it updates the Start date to the new day, but the finish date stays the same. What function can I use for this? Example: I have Post #1 with a start date of…
-
INDEX MATCH with two criteria
Is there a way to reference a ROW and a Column and return the data? So in the primary column, I have project numbers, and in the first row i have pasted column names, so I am looking literally look up the cell (by Row and column) not using Index only, because it requires column numbers, but using match.…
-
Formula to return the week ending date based on another cells date
Example: If cell A3 contains a date of 04/25/23, I'd like cell A10 to auto-populate a week-ending date of 04/28/23. All the dates in cell A3 will occur sometime Monday thru Friday. The day in cell A10 will always be a Friday. I've been searching community resources but haven't found this specific ask.