-
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…
-
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…
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
-
Using Resource View without 'named' Users
We want to use Smartsheet to build out our sales pipeline (consulting biz) and expected resource allocation. However, we don't have 'named' users (resources) until the project closes and we find the correct contractor. Is there an easy way to utilize resource views but without having named users invited into the smartsheet…
-
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:
-
Return top 5 occurrances
I have a sheet to track customer requests (500+ rows), with a Salesperson column and customer column, the salesperson column is located farthest to the right of the sheet whereas the customer column is located on the 1st column. What I want to do is write a function that will reference a given Salesperson contact and be…
-
IF AND Function
Dear Smartsheet Wizard, I'm trying to create a function but I'm running into an error. The IF - And function I'm creating basically needs to do the following: If salesperson 1 is = "Yan" then deduct 100 from Profit and his commission should be profit*0.5. Otherwise, deduct 100 from Profit and commission should be…
-
Ability to Create Order Form
I have search through various posts but can't seem to find exactly what I am looking for. I want to replace an excel sheet with smartsheets for demo order requests from the sales team. The existing excel sheet has a drop down of all the options that you can choose from and once you choose an option, it will auto-populate…
-
Return 1 if YEAR and MONTH is equal TODAY
Hi, I have a formula: =IFERROR(IF(MONTH([Sale Date]2) = MONTH(TODAY()), 1, IF(MONTH([Sale Date]2) = MONTH(TODAY()) - 1, 2)), " ") and it worked until we have two years in one sheet. I would like to know how to add YEAR to this formula so that we can compare not only MONTH but also YEAR. Thanks.