Nasir@EBC✭✭

Comments

  • Thanks guys for the support! However, the issue that I am facing is a bit different: In the report view, the child rows are not even appearing right under their parent row! So in this case I cannot even figure out which child row belongs to which parent row! Any suggestions please?
    inParent/Child Hierarchy when Building Reports Comment byNasir@EBC 12/16/22
  • Thanks a ton Paul !! It worked!
    inOverlaps in Start and Finish dates Comment byNasir@EBC 09/28/22
  • Hi @Dominick Vargas Even I've been waiting for this feature to be introduced, such that if a field value is not in line with my expectations, then there should be an option to disable the SUBMIT button. This would prevent us from receiving invalid data, and then moving it to other sheets; or sending error emails to the…
    inDisable Form Submission Comment byNasir@EBC 09/20/22
  • 我女ould agree with what @George Lie says here. An app that basically works on the database model, must be capable of handling hundreds of thousands of rows of data. Smartsheet is an extremely well-designed (or almost an indispensable) solution, but perhaps the only aspect that makes it look somewhat weak, is the time it…
    inSLOW everything runs very SLOW Comment byNasir@EBC 08/30/22
  • I think my issue is even worse! The vlookup function is pulling data from all the rows EXCEPT rows 244 to 266! The format of all the columns is identical, and I just can't figure out why it's happening like this. Any tips please?
    inVLookup #No Match Error Comment byNasir@EBC 06/04/22
  • Thanks @Genevieve P. for reviewing the request. Here's the WorkApps URL "https://workapps.smartsheet.com/app/2WX5WGh5xpgQM4mwcxQJ6p86gc/3hcWmHmr9hrj8" It is basically not an error, rather a requirement that may arise if, say, the app admin wants to move the Home role above all other roles —mostly because it would otherwise…
    inSudden change in the order of WorkApps roles Comment byNasir@EBC 05/10/22
  • Dear Marcus, I have developed a workaround that will allow you to pull only the unique rows of any duplicate records. Please let me know if you are still looking for some help on this! Nasir
    inRemoving Duplicates Comment byNasir@EBC 03/28/22
  • Hi All, I have a tried and tested solution to this problem. On the left side of the Task column, insert a helper column titled "Parent Task" Insert the following formula in the helper column: =PARENT([Task Name]@row) Now right click on the cell containing the above formula, and choose "Convert to Column Formula" That's it!…
    inIs there a way to show a parent task on a row-sheet report? Comment byNasir@EBC 01/18/22
  • Hello @Kegan Copas I'm also facing the same issue. Regarding your suggestion on the Metric Sheet, yes we can pull the data BUT... we cannot "dynamically" filter it based on some specific dates! (as we can, through the reports). For example, if we filter last 7-day data in a sheet, then it will update that data ONLY when I…
    inColumn order in charts Comment byNasir@EBC 10/25/21
  • Hi All Can we restore a backed-up version of smartsheet data? If yes, then please let me know the procedure. Thanks
    inRestore a backup version of a sheet Comment byNasir@EBC 10/22/21
Avatar