-
Looking for formula
I'm new to using Smart Sheets and looking to calculating aging date for invoices for tracking purpose. I tried several ones I used for excel but does not seems to work here. I did also use some of the formula's people had suggested on the blogs here but no luck. Please help. What I have is the invoice date and need to know…
-
Conditional calculation?
I am trying to create a formula that will calculate sales commission based on which marketer is named in another column. I have two marketers who are at different commission levels. I would like the Commission column to automatically calculate the commission total from the dollar value in the Services column, based on…
-
Help on formula: Monthly savings calculation
Hi, Please need your help on how I can calculate my monthly savings on completed projects. I am currently using the below formula but couldn't get it right. =SUMIFS([Negotiated/Potential Savings]:[Negotiated/Potential Savings], [Actual End Date]:[Actual End Date], <=[Summary Info 3]41, Status:Status, "completed") Kind…
-
RYG Ball Formlas
I am having a hard time putting together the formula for my Health Column- RYGB Ball. I need the formula to be the following. Any chance some one could help put this formula together for me? Thanks * If Status is Not Started then Health is Blank * If Status is In Process and is equal to or past the Due Date then Health is…
-
Trying to use sumif with dates
I am trying to sum values from Study column which only have a value in start date column less than today's date. =SUMIF([start date]1:[start date]9, "<"&today, [Study]1:[Study]9) the result is #UNPARSEABLE and I don't know why. Does anybody have advice? ex: start date Study sum 11/1/17 12 11/1/18 3 12
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
Help on Formula: if function
Hi all, Please need your help. I'm new to formulas and I've been trying to figure out the right formula for my project status and progress report but I kept getting errors. I have tried the below formula in excel and it worked but not in smartsheet (the smartsheet formula below is another trial I did that did not work).…
-
Sum if there is any text in a range
I'd like to make a sum total at the bottom of a sheet in which I add only amounts if the cell in the same row has any text. I tried using this formula: =SUMIF(Location221:Location90, >0.01, [List Price]221:[List Price]90) , but it only works if there are numbers. Any help would be appreciated!
-
Compare two dates and apply conditional formatting
I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9/30/17 and IN SERVICE = 5/10/17, I want both cells to be red. I understand That I'll have to use a third column to base the formatting from but I cannot get…