-
Line Item Transfer to Another Sheet using Formula's
I'm working on a project and am hoping for some advice from the community of experts! I have a sheet that serves as an ongoing list of projects and information about those projects - once a decision is made to either fund the project or deny the project, I'd like that line item to appear in another sheet. My main sheet…
-
Using "@row" reference with ";" as the separator
Hi the community! I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";" When I use the "@row" reference in a formula, then extend this formula and come back to it, the formula separator becomes ",". So if I modify the formula without…
-
date trigger formula
Im wondering if there is in smartsheet formula that can transfer task name to another sheet when the date is today?
-
Linking Data
I need help linking data from one sheet to another. I need the data to update real time, so that should a salesman update a projects, or ad another project in that satisfies certain requirements, the data automatically updates in real time on the linked page for my operations team. Reports will not work for this.Reports…
-
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
Accounts Receivable formulas for SmartSheet
Good morning, I am seeking formulas to help setup my accounts receivables SmartSheet based on the Status Stage from my project management sheet. Is there a formula for extracting from my "Invoiced" stage the cell history date from that cell. This is the date the status of that cell turned to "Invoiced". Then I will like a…
-
How to create Report/Chart/Sheet for overview of many?
We have a Sheet for every project. Every Sheet is basically a checklist. The checklists are similar but wording and order of the tasks are different. I want to create something that will bring in just the "Completed" checkbox and the Primary Column of each Sheet/checklist so that the overall status can be easily seen. How…
-
Text vs duration and dependencies
Hello everyone, I need to create an easy to use sheet that will allow my team to choose a task type from a drop down list that then auto-populates an SLA column and from that works out overallocation of resources. So far I have tried to do a VLOOKUP from the task type to our SLA times but that comes across as a text entry…
-
Referencing External Sheet Data
Is there any way to reference data in another sheet based on a cell's contents? I have inventories that have asset tags and associated serial numbers. I have a separate sheet for maintenance logging. Is it possible to type in an asset tag and have the corresponding serial number auto-fill in the adjacent column? Thanks!
