-
Updating/Refreshing my file from a different website?
I have a file that I need to use updated fuel pricing at all times. The website my excel file is linked to updates once a week, usually on Tuesday. Need: How can I have this sheet refreshed from the website (EIA.gov) onto my Smartsheet file? Nice to have: I would like the data point I use on the sheet to be rounded to 2…
-
Month to Date and Year to Date spending
I have a sheet which contains date and amount spent, among other things. I want to show a MTD and a YTD metric on a dashboard. I am assuming I need to make a new sheet with a formula pulling data from the original sheet. I would like this to be ongoing as the original sheet is updated and then at the start of a new…
-
Is there a way to copy a single field to another sheet with Data Shuttle or in another manner?
I need to copy a Key field to various sheets at certain points in the processing. We keep having errors on the sheet [running out of space] when everything is on one sheet, so we are separating out based on processing criteria. We do not want all of the row to move, as this is where are trying to save fields and keep the…
-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…
-
INDEX(COLLECT( )) where some rows are blank
Hello Community! I'm missing something here, but I'm not sure what. In this sheet I need to pull a date from a master sheet. The formula works perfectly for the first two organizations, but then the next one it pulls is simply the next cell in the date column in the master that isn't blank. It isn't the date that goes with…
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
-
Link cells with children
I have multiple project gantts that I would like to summarize on one sheet. So far, I can only link the top-level task to the summary sheet. Cell linking ignores the project hierarchy. If I try to link the entire project the hierarchy gets flattened and I would have to re-indent everything on the summary sheet. It would be…
-
Relational Database?
Hello All, We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with each other? Some language in the site alludes to needing to integrate Smartsheet with an…
-
Conditional Formatting Referencing Other Sheets
Hello, I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names…
-
How to put in exact dates when tasks have predecessors linked
I have all my tasks linked to predecessors so that dates adjust correctly, but I am now unable to change the date to something farther down the line unless I unlink everything. Does anyone have an idea of how to fix that? Thanks
