-
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…
-
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
-
How to get automatically an average data based on date rage on a daily basis
We are using form to create performane data per robot per run ( input can be few times a day) I need to start measuring daily avereage for their performance seperately (1 called North 1 called South) but can't figure out formula for it and then I'm assuming creating a chart would be straightforward? but not done it before…
-
Linked cell won't show currency format
Hi, Please see below. Some linked cells are showing currency format while other cells are not. Current setup: Source sheet (linked from)- numbers are all set to currency format with column properties set to "text/number" This current sheet (linked to) - all columns proporties are set to "Date" with "restricted to dates…
-
Change Cell Workflow across sheets
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another. My scenario: I use a date/time based automation to copy pertinent cells from one of my…
