-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Comments - Keep important ones on top
Hello, Are we able to lock comments on rows or sheets do that they stay to the top?
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
-
PayPal integration samples
Hi All, Does anyone knows any place where I could find any samples of how PayPal can be integrated into Smartsheet? TIA
-
Row Locking Now Requires Paid User
For the past 3 years I have had free license users managing a sheet and locking rows. Seems as of yesterday they lost the ability to lock rows and the annotation states that they need to upgrade to a paid user in order to do so. Can someone confirm this is the new normal? Maybe provide a link to a announcement that states…
-
Summary rollup
Hello, I've never used Smartsheet and would appreciate your help. I'm working on a budget, we have 40 departments and each department needs to submit their budget. So I have 40 sheets and they are exactly the same, (same columns and same rows), the only difference is the data. What is the best way to add up all these 40…
-
Not Receiving Email Alerts for "Changes to New Supplier Setup for Streamline"
My peers setup my profile when I joined Serta Simmons Beddings to get email notification of requests made to add new supplier to Streamline. I am still not receiving the notifications, although my peers are. My profile matches theirs apparently. No one internally can help me resolve. Does anyone have any suggestions? Thank…
-
Prorated Rent Schedule Formula Help
Need a formula to calculate what is due per calendar year when the rent amount changes year to year (midyear) Any help appreciated! 06/01/19-05/31/20 Total Rent Due: $175,000 06/01/20-05/31/21 Total Rent Due: $200,000 Total Rent of 2019: Total Rent of 2020:
-
Notifications, Report or Dashboard
i am new to smartsheet and using it to keep track of inventory across multiple locations which have different contacts by location. What is the best method to send a scheduled listing of assigned assets to each contact owner. Would like them to only see their assets and be able to change the location if they no longer have…
-
Nested if()
Hello great community. I'm new in Smartheet and I've a problem and even don't know if a solution exists. I'm trying to create a sort of automatized timesheet for my team. I would like them to connect to the same sheet. They have to select their name in a list ("Team" column), and the type of mission they've managed in an…