-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
Array and Index Training Records to pull who needs to complete something within a date range
I manage training records and am creating a dashboard to manage who needs to complete a training. I have a master sheet with the employee name, and a reference column to them completing the training and when it is due I then have a calculation sheet to count how many people fall within that date range =COUNTIFS({HiPot…
-
Multiple cells locked to single formula in same column
I'm relatively new to Smartsheet and use it as a tertiary tool, so apologies if this is a 'basic' question. What I want is to tweak a formula on one row of a column and have it apply all other rows that reference that cell in the same column so I don't have to copy the tweaked @row + Parent, Children, or Ancestors…
-
Cell Linking Contact Lists
I have two sheets I want to link but I am having an issue with the second sheet listing the linked cell data. The original sheet has assigned contacts that I want to link to my second sheet but when i create the link, the cell does not populate. I made sure the column formats and contacts lists were identical on both…
-
Copy & Duplicate pack of sheets/Folders
Hi , I have number of sheets to collect data periodically on monthly basis with own automation/task and work flow and many of sheets are linked and reading data from source sheets . The above folders/sheets i create them every month using template function creating the sheets , and linking them again / rename it every…
-
Fast status updates based on parent cell
I would like to make our status updates faster by utilizing the parent/child cell(s). If the user changes the status in the parent cell (dark grey line) to "Completed" then the child and grandchild cells would change to completed. If the user marks the child cell as one of the following statuses then the grandchild rows…
-
How do I extract full URL from Hyperlink cell?
Hi all I have this Opportunity ID column in my sheet that's connected to Salesforce. All cells are hyperlinked with the opportunity in Salesforce. This column is created like this by the Salesforce-Smartsheet connector and it's handy because of the hyperlink. I need to send the Salesforce URL to another sheet, but if I…
-
"Link from cell in other sheet" is returning a "blank" - but the reference cell has info? what is h
Hello - This is a bit confounding, I have the links set up correctly and it returns a blank cell. I double check the source cell, and there is the correct information. Can anyone help? Thanks
-
easier references to other sheets
Hi all, I prefer to use references of the form {sheet_name Range 1} rather than using the "link from cell in other sheet..." because the formula can be copied to another cell where trying to copy the direct-linked cell only copies the value, not the link. If I have a lot of cells all linked to a particular cell in another…
-
Collect information from a changing database
I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API) The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products. I wanted to do a vlookup on these 6 sheets to…
