-
Is there an automation/formula that allows a copied row to be updated?
I have created a master sheet for grant invoicing. We have 14 different institutions who received the grant and who will be submitting invoices to the master sheet. I have created a workflow for each institution so that when they submit to the master sheet, that row will be copied to a separate Smartsheet with just the…
-
Matching Neighbor Cells or Rows to Most Recent Date
Hey All, Background: Im trying to build a fluid dashboard that tracks information coming in from a form. This form is then routed to several sheets where I break it down further based on certain criteria. I am looking for a way to report on the most recent metrics in the given sheet using the sheet summary feature to make…
-
How can I create a sheet that counts occurrences of a word in multiple sheets?
I would like to create a sheet that tallies up all the instances of certain words, such as 'retain', 'rotate', 'textile', etc., from multiple sheets. So it would look like: Retain - 30 Rotate - 50 Textile - 20 etc. Is this possible?
-
#IF INDEX/MATCH Returning #INVALID OPERATION
I am fairly new to formulas in Smartsheet, and I am having trouble with the following formula where I am trying to check a Checkbox from another sheet ("Devices Secured") and set a Text/Number value ("Device Security OK") to either "OK" or "Not OK" based on whether the Checkbox is checked or not. This seems fairly…
-
Predecessor with Calendar Days on One Item
When invoicing, we use a NET30 policy where the payment is due in 30 calendar days. The remainder of our project timeline functions in working days (Monday - Friday). I want the "receive payment" step (line 31) in our timeline to be dependent on the "send invoice" step (line 62) and to appear in the tasks when the invoice…
-
Can you copy specific rows to a new sheet without bringing over child rows?
We do our weekly reports (Good, Brutal Facts, and Help Needed) within SmartSheet (Have 5 levels of Hierarchy with "+" and "-" icons), and our process has gained traction with other teams. We are looking at how to scale our process to accommodate another level of leader (Currently goes from Managers -> Director and Director…
-
Ability for cell linking to add new inserted rows
I created a sheet utilizing cell links in order to create all of my formulas needed for my dashboard. However, I noticed that the cell linked columns do not add the newly inserted rows from the master sheet. Is there a way for the cell linking to add the newly inserted rows from the master sheet or do I have to continually…
-
Formula when a column has a checkbox
I cannot seem to find this answer: When a column has a checkbox, another column must have data in it or it will turn red Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red. On Site Person <star> Contact List or cell is RED
-
Using Datamesh then want to cell link to source so updates will appear in target
I am using a master project list, filtering out certain jobs with a report, then using DataMesh to move the jobs onto a Intake sheet. I then want to cell link critical data from the source into the Intake sheet so any updates from the Master are reflected in the target sheet. I create the Inbound cell link, but when a new…
-
Index/Match Leaving Blanks + "#NO MATCH"
I apologize if this posts twice... I am a relatively new Smartsheet-er experimenting with the capabilities of the Index/Match function. I have two sheets, one that tracks project status, and one that I would like to link to the first, showing live project status updates by matching the ID # columns. I have created a…
