Hello, I am looking to transfer my excel reporting efforts into smartsheet, but I need the exact function when comparing the updated numbers every week. Any suggestions?
How would you be using it? Typically in Smartsheet you can just use something like
=IF([Column A]@row = [Column B]@row, 1, 0)
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
I would be running the weekly data to see if anything changed from the week before. So I would be matching it up against the prior weeks numbers to see if it all still matches or if something has changed and it will tell me true if no changes and false if something is different.
Hi @DeMetria Hines
I hope you're well and safe!
Please have a look at my post below with a method I developed.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Where are the previous week's numbers located? Are you updating the same cell each week, or do you have separate columns?
I have separate columns. I am only making updates to the original column if it comes back as false.
Are you able to provide a screenshot for reference and an explanation of how the sheet is filled out?
Here is the data from excel. I need to put it up against this same column in smartsheet and see if the numbers have changed. Is there a way to do that?
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
©2024. All Rights Reserved Smartsheet Inc.