-
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?
-
Building sheets that talk to each other
Hello, I have two sheets I would like to reference data to and from and I understand how to us the =VLookup option BUT what I cant seem to get it to work. I basically want one sheet that our shipping team updates to automatically update another sheet my purchasing team uses. The columns have dates and check boxes so when…
-
RYG Ball Automation
Hi there, I am trying to automate the 'Health' column on a sheet. I have it set up to turn RYG when a certain status is selected but I would also like it to turn Red if the Due Date or Due for Review is a past date and the status is still listed as anything but 'Complete." I currently have this formula in place…
-
Need help with formula to calculate end date with % complete.
Hello, I need assistance with creating a formula to look at the end date and % complete columns. If the end date is nearing and the % complete is less than 100% the corresponding RYG should appear. The durations of each task varies from 1 day to 100 days depending on the project phase. What formula do you recommend for the…
