-
How can I link my sheets in Workspaces?
Hello, I'm wondering if there's a way to link my sheets in workspaces, we want something that will transfer onto the other sheets or have something in red trigger another sheet into auto generating it there to know what task needs to be completed. Should i just do a master sheet and that will link them? or how can i go…
-
help with formula's
hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Name]@row), VLOOKUP($[Cable Name]@row, {K2 Power/Motor Cable List Tracker Range 1}, 1, false)) Motor, 0) I would like it to say…
-
Need Help with Formula for Metrics
Hi, I am stumped at a formula for this sheet. Please see picture below. I am trying to calculate an action taken goal where we take the levels standard, urgent, and immediate and the action taken days. The parameter is for standard 3 days, urgent 1 day, and immediate 0 days. I want in the action taken goal column the words…
-
Is autofill possible in this scenario? and how
I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I would like the next column to autofill with 18000 for the expected participants. Is there a way to do this? Thanks
-
Pulling out data from a master sheet
Hi all, I'm in need of a solution to track activities. There is a master sheet that I have view access to where items get added by different parties. I want to pull out data based on a filter to create a tracking tool to make sure that my tasks in relation to the tasks in the master sheet are completed. Think about…
-
Formula for Referencing Cell Above Current Cell?
I have created this Smartsheet, where my team can record orders raised each month. This would then link to a dashboard (which would have to update automatically each month) to show monthly statistics regarding the orders from that month. This is what It currently looks like. Each month is child of its year and the orders…
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
Tracking a sum from separate column of specific values
Hello, First, I want to thank all of you for your help on this community. I'm learning a lot and this place has helped me out immensely. I've looked around and have found some similar questions, but I can't seem to get this to work, so I want to turn it over to y'all. So let me start with a snapshot of my sheet. What I…
-
Am unable to retrieve Dates from one smartsheet to other
While am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect Value
-
Workflow to Update Date to TODAY() until another cell = 100%
I have 2 cells in a column: Which displays a % from 1-100 Which should show a date Is it possible to use a workflow or other automation to daily (at 12:01am or any other time) update the date field to TODAY(), but to stop updating it once the % field = 100%? Thanks in advance!
