-
SUMIFS, cross-sheet reference based on dates.
Sorry if this is a duplicate. I couldn't find an answer that fit my problem.. Formula: =SUMIFS({AccHours}, {ShipDate}, <=Date3, {completed}, <>"x") All references are from another sheet except Date3. Date3 is a formula as well, which is TODAY()+2. This works in Excel, but doesn't seem to work here. I don't get an error,…
-
How to update dates to a new future date
Hi I use smartsheet as payroll check system. I normally maintain a group name, pay date, direct credit date. For some groups we pay weekly and for some we pay fortnightly. How do i automate date column with future date once i complete the payroll on certain date. Example Group Name Payroll preparion Date Direct Credit Date…
-
Prevent deletion of rows if it contains locked cells?
We are trying Smartsheets for a project and are running into a major issue. The sheet contains checkboxes of things to do, along with dates, and who did the particular task. It is crucial that the 'Task' and 'Date' columns be protected. Unfortunately, we're finidng that if you are an editor, even though these two columns…
-
Barcodes count and verification
Hello all, I'm looking to implement a process where I can count how many times a particular barcode label has been scanned. This will help me to verify that all the items that belong to a single unit are leaving the workshop after going through the fabrication and painting process. Can you think of a process using…
-
eliminate INVALID DATA TYPE when using a IF statement to display the month
I am using an IF statement to display the month but when I don't have a date the column is displaying #INVALID DATA TYPE. I understand why this is happening but I don't know if I can also incorporate the use of an IFERROR statement nested. What is the correct way to eliminate the #INVALID DATA TYPE? Here is my IF Statement…
-
Formula Training
I'm training a guy to support Smartsheet for our company. He's pretty good with most of the functionality, but he has no experience with formulas. I thought I'd put together a training program for him to help him learn them - starting with basics, then building into nested formulas, etc. I want to give him some samples to…
-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
How can I get the number of checkboxes checked in a single column ?
Hello, I'm trying to get the number of checkboxes that are checked in a given column (more precisely, A10 - Transcode colum) without using another column to do so (in this case, Valeur A10 - Transcode column which displays ''1'' when a box is checked and ''0'' when it's not the case). As you can see in the screenshots, I…
-
Allowing multiple contacts per cell leads card view is removed.
Card view is removed automatically when changing configuration of a contacts type column to multiple contacts per cell. I need that card view.
-
Predecessors (Finish to Finish & Finish to Start
I may have a basic misunderstanding & need some clarification. I have a task #3 (the Effective Date) of a contract. Further down the project I have another task.... #20 - Purchaser obtains an updated Survey & Title Commitment. Task #20 can begin on the Effective Date (task #3). Further down the project I have another task…