IanNEmployee

Comments

  • This is such an awesome use case. I agree that creating a sheet to track all the formulas and where/how they're being used is EXTREMELY helpful for a)our Support team b)your support folks c)anyone else needing to understand the solution. An alternative is to use the Column Description or Sheet Summary (unless you're…
    inCross Sheets in action with multiple formulas Comment byIanN 03/07/23
  • Assuming I can't find the original owner of that $20, I initially thought about helping someone in my local area who I know to be homeless at least get a meal. Then I realized that the $20 would go much further if I took it to my local food bank, so donation to a Food Bank is my answer. It can help so many more people that…
    inNEW Question of the Month - Join the conversation and receive a badge Comment byIanN 03/07/23
  • Hi TK, Though we don't currently have a direct integration with ArcGIS online, our API endpoints are open and available to use. Using the API would allow you to customize how data is synched and perhaps help you automate that data transfer. Our API Documentation can be found here: https://smartsheet.redoc.ly/. I did a…
    inGIS Mapping Comment byIanN 03/07/23
  • Hello Diego, i would ensure that your destination column (where the 100000 is) is formatted as a currency column. To do this click the column header to select the whole column, and then click on the currency icon in to toolbar. That should format all existing rows as $ amounts. Rows added after this should inherit the…
    inLinked Cell Format Issue Comment byIanN 09/07/19
  • Hello Teodora, With your current formula, any positive integer will return a Yellow dot because they're all greater than 0. Once the formula finds an argument it can use, it will ignore the rest of the formula. In this case, you might instead consider using something like the following: =IF(ISBLANK([2019 Budget to Forecast…
    inIf than statement Comment byIanN 09/06/19
  • Hello Cyril, This sounds like something our Support Team will need to look into. Since you've tried the basics of clearing cache and using an Incognito window, it doesn't sound immediately browser related. I recommend have her taking screenshots (full screen) that can demonstrate what she's seeing to our team. In addition…
    inA user can't access sheets Comment byIanN 09/06/19
  • Hello Jason, For questions with errors that DataMesh is throwing, it's probably best to work directly with our Support Team: https://help.smartsheet.com/contact. There are a few things you'd want to check, but the likeliest would be that when using a sheet with Dependencies enabled (Gantts are usually dependency enabled),…
    inDataMesh & Gantt Charts Comment byIanN 08/29/19
  • Hi Ezra, At this time, Resource Management doesn't have a way to exclude certain items. If Resource Management is enabled for those sheets and a contact is assigned, then they'll be included. This would be a great Enhancement Request to submit though, as I can see a number of use cases already. Please click the link in the…
    inResourcing is looking at SCC template gantts Comment byIanN 08/14/19
  • Hello gbaty, There are a lot of variables that would need to be investigated in order to get to the bottom of this. Please reach out to our Support Team here: https://help.smartsheet.com/contact. When you submit, please be sure to let us know the email addresses of the affected users. If you can, please also provide some…
    inThree bars not visible to some users Comment byIanN 07/23/19
  • Hi Tara, I reached out on the ticket that you submitted. This should be resolved. Thanks, Ian
    inError when opening a sheet Comment byIanN 07/22/19
Avatar