-
Auto fill information in sheet when a check box is checked in a different sheet
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet. When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in…
-
IF statement to pull value from another sheet if a checkbox is ticked
Hi all, I'm trying to have a link between a risk register into an issues register and I don't know if it's simply my code or if this isn't possible in smart sheets. I have a column in my risk register with a checkbox that gets ticked when a risk has become an issue. I want my issue register to have a column listing the…
-
Cell linking
Hello all of my smartsheets are coming up with the message - more sheets referenced than allowed and I am not sure what to do about it as the sheets were created for me and i know they all link to a 'master' sheet and now that I've added more rows this message appears every time I open the sheet. Can someone help me out as…
-
Zapier and Formulas
I'm trying to use Zapier to input formulas into a Text/Number column (which does support formulas) and it comes over as a text string: '=INDEX(PARENT(), 1) I'm using Control Center which creates new rows on a sheet via cell links, but the auto-fill function doesn't seem to work when the new rows are added here; hence…
-
PROJECT DURATION - OVERIDE DEFAULT
I use a smartsheet to manage engineering tasks I have columns that calculate task duration based on work types I now want to convert this to a project sheet and have the task duration driven by an existing column Example: I would like my "Planned Hrs" column to determine the task duration Does anyone know how to have the…
-
Summarise Tasks into single cell
Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets for planning in my company, which is currently manually updated. I am hoping to link these sheets together so that…
-
Function Help - Sheet References
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. I need help with a specific formula that would…
-
Deleting one outgoing cross-sheet reference ended in ALL references from the same sheet being delete
Hello, I spoke to Support on the phone yesterday but we haven't had a definitive answer on what the expected behaviour for this scenario is. I'm curious to see what other users have experienced. In the the "Edit or Remove links" > "Outbound links" section of the Cell Links: Consolidate or Maintain Consistency of Data…
-
Index or Vlookup or What?
Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match…
-
SUMIFS with 3 conditions
Hi I am trying to calculate the total number of worked hours within a week/ month which match 2 more criteria. At the moment I have fr the monthly formula 9 September): =SUMIFS({003 Project Timesheets Range 2} , {003 Project Timesheets Range 1,"Noemi K", {003 Project Timesheets Range 3} , "Testing" and ({003 Project…