Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to link worksheets for a single record of data. I have additionally tried using parent child relationships in a single worksheet creating a catch all worksheet now 100 columns long. I need to establish a template which can be duplicated and expanded for new client set up. I am attempting to use forms to update each record at each phase of the project. The form URL hyperlink information is not duplicating in the template. I feel like I am close in various versions I have created at this time and I continue to have issues with the final integration of this information. Is there anyone that is available to help me telephonically and with shared screen access to finalize this for roll out to my clients. At this point I do not even now the correct question to ask.
Hi,I'd happily work with you and help you with setting up a solution.
Let's book a free discovery call. Please e-mail me at andree@getdone.se and well take it from there.
Best,
Andrée Starå - Workflow Consultant @ Get Done Consulting
Hi Summer,
How did it go? Did you get something set up?
Have a fantastic week!
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi All i am trying to determine the stage that a project should have readhed by today, based on a series of milestone dates across the row however, in this particular example i am getting #invalid operation which may be due to the blanks. they are blanks because they currently have no date which is probably a flaw in the…
Looking to calculate the % of empty cells in a sheet for all rows that have data, with the intention of excluding any rows beyond my last row. I'd like to use this to motivate relevant stakeholders to completely populate the columns. Thank you.
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
