-
Link clients, jobs and opportunities
Hi guys. I use SmartSheet to track clients, jobs and opportunities. I have a sheet for each. For the most part, it works well. But the one area it's letting me down is linking relevant records. I'd like to be able to go to the client card and see all their jobs and opportunities. And I'd like to be able to go to a job or…
-
Detecting Cell Changes, Modifying other cells on update.
Hey guys. So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur. The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: =IF([% Complete]2024 = 1,…
-
Cell Linking Max Count
So when I try linking a cell I got the following error "Your sheet has 5000 inbound links" I understand that this is the maximum number of links but, what is considered an inbound link? For instance, I know that the linkInFromCell Objects can have a status like "OK", "BROKEN", "NOT_SHARED", "INACCESSIBLE", and some other…
-
Do you support "Hammock"?
Do smartshett support hammock?
-
Trying to do a group IF statment
Not sure how to ask this but I am trying to set up a tracking sheet that will automatically pull info from a master sheet. I would like to send out a form from for someone to fill out and all they would need to do is put in the job # into the form, and on the track sheet it will automatically fill in the rest of the…
-
Link if?
Hello! Is there a way to link cells, or even just copy cell/row info, if a specific criteria is met? I am new to Smartsheet and haven't been able to find anything to do this. This is the situation: I am using a webform to create Purchase requests. I have approvals set up. Once the request has been APPROVED, I want specific…
-
Combining Spreadsheets: linking vs reports
Hello, I have a multiple spreadsheets that I would like to update to a master spreadsheet. Each "child" spreadsheet have the same named column(s) but only certain cells from the column need to roll up to the parent spreadsheet (these are identified by a check mark). The report function works extremely well for this;…
-
Updating Info on the Projects Index Sheet
Hi all, Consider that I have an index sheet that lists all the projects (active or not), with the current task, it's description, timescale, owner of the task, and also the task that will come next. Parallel to that, I have individual sheets for each project that list all the information above, and also all the remaining…
-
Sync cells content according to date in different sheets
Hi there, I'm new to Smart Sheets and I'm trying to achieve the following. I'll try to explain. I have manually created a calendar, in normal grid mode, which has a 3 month view side by side with blanck cells next to each day where i can manually add content. I have another sheet, in card mode, where I can manage basic…
-
Formulas // How to set up one sheet writing to another
I created a project request form for one of my team members -- others on the team enter a request by filling out the form, and so the sheet becomes his workload queue. Another team member has a schedule on a separate sheet with some items assigned to the same resource. She asked if there is a way that if she selects his…
