-
Using SUMIF Formula Help
Hey everyone! I just started using Smartsheet and so far am blown away by everything! At the moment, I'm trying to use the SUMIF formula to calculate a total cost but only if the number being used is below 0. For example, If Column A is a negative number, I need the formula to subtract it from Column B, however, if Column…
-
Formula that will automatically add $25 to the cell
tracking installations of certain units. When unit install gets cancelled checkbox for "unit cancellation" is checked. What would the formula be that when the cancellation box gets checked it would automatically fill in $25 into a "trip charge" column? Thanks!
-
Date
Hi! I have a tricky formula I'm trying to calculate, but with no success so far... I have to different sheets that I'm looking on. Sheet1: Planning and monitoring sheet Sheet2: Work reports The formula challenge: In Sheet2 our guys at the field are reporting on different predetermined projects. They report which date they…
-
Sum rows if shared value in another column?
Hi, I'm trying to summarize hours worked on each project for each month. My list of projects changes regularly with some coming in and some going out. Data is collected weekly so there will be multiple entries for each project. My thought was to SumIF the project identifier matches. I'm new to Smartsheet and have searched…
-
Exporting Excel formulas
I noticed that formulas, even simple formulas are not exported to a Excel. I have a big smartsheet where we created butcket that has additions per row (summarized) and we noticed that they're not exported as formulas in Excel. It's a shame because we have to start over in Excel an create template and data again. Is there…
-
TODAY() Function is Replacing Previous Date
Hello, I have a column in a production spreadsheet that I am utilizing to enter the date of which one of our production members completes an order. The columns are set up as follows - one column is an initials column where a production member selects their initials once they complete an order. The second column contains…
-
Calculating Weekend Days Between Dates
Hi, Looking for a way to calculate the number of weekend days between two dates. Many calculations use the total number of days and divide by 7, but this only gives you total weeks. For example, if a task starts on a Thursday and ends Monday the output should be 2. If you divide this duration by 7 it will give you nothing.…
-
Daily Average formula counting too many days...
Hello, I recently had pro desk help set up the following formula and it is counting more days then it should. I would love your help in solving this issue. Thanks Intended formula function: My smartsheet has date entries with totals. In my other sheet that is gathering the grand totals from this sheet, I wanted to come up…
-
Help needed with formulas - paid work opportunity!
Hi everyone, My colleague and I are new to SmartSheet and we are having some issues with a few formulas and we can't quite work out what has happened. We are offering paid work at an hourly rate for someone to join our team to help troubleshoot and fix our SmartSheets issues. If you're interested, please let me know!…
-
Vlookup: Retrieve multiple responses
Looking for a way for my Vlookup function to retrieve multiple responses from the table. I currently have it set to find the purchase order number associated with the work order, but sometimes there is more than one. Has anyone seen a way to do this?
