-
Checkbox Parent Cell if any Children cells are Checked
Hello, I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked. Can anyone help with that? Thanks
-
Countif with Dates, Smartsheets keep adding blank lines, Invalid Data Results
Hi Guys, Firstly, thanks for the help. I am trying to add records and have cumulitive counts based on dates. I am counting the date column of the new input lines with the following formula: =COUNTIF([Created Date]:[Created Date], TODAY() - @cell < 7) for Records added in the last 7 days and: =COUNTIFS([Created…
-
Formula Help!
Hi Everyone, I am needing help with a formula. I need it to function as =if "Wet Paint" has check mark, change "Lane Designation" to Wet Paint. Thanks for the help in advance.
-
Assinged too.....how do i
How do I remove extra names in the drop list? In the early days I entered the wrong e-mail address, now I have two Heath with different e-mail addresses, I cant remove one of them.... Can someone help please ?
-
Calendar dispay
I have a task sheet with assigned dates. They are assigned to people. What I want to do is create a calendar showing who is assigned a task each day. However the calendar view is showing the ID number instead. How can I change this?
-
Trying to add a Sheet Data widget to a sight
Hi, I'm trying to create a Project management Dashboard but for some reason, when I click on "add a widget", I don't see the option to add a Sheet Data. Does anyone know why and how I can do this? THanks! Carine
-
Date linking or date formulas
Hello, I am not sure the best way to summarize what I am asking in to a search string so thought I would just ask the community. So right now I have a very dynamic production schedule, since we are a new company and still learning / growing we constantly update our production schedule (sometimes daily). My question is, if…
-
Is it possible to set due dates based on a formula?
Hello, I've imported an Excel sheet and my formulas aren't working. I'd like to automate due dates where the duration may change based on a numerical figure. For example, if there are 10 items to move, it will take 2 days for each of 4 tasks, but 100 items to move will take 5 days for each of 4 tasks. I've been playing…
-
Assembly + Inventory Tracking
I've created a smartsheet to track every unit we sell of one of our particular product lines. The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route",…
-
Method of linking data from source sheet with an increasing number of rows
The function I am looking for would allow for data to be pulled from a source sheet which is increasing in size and be kept in sync for maintaining accurate information. To help explain, at the moment I can link an entire column of 'Engine numbers' with number n (approx 300) rows and the corresponding data with no problem.…
