-
Simple Sum formula not working
I'm running into an issue where it appears the formulas that I have returning a number are not available for simple math in sum formulas. Any suggestions? For example, I have a column that produces the month a project will close based upon the estimated completion date currently linking in from the individual task lists. I…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
-
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:
