-
Data Uploader Not Displaying Time from Import
Hello, I am using Data uploader to import data from an excel sheet. It is critical that we pull in the date and time from the sheet. However, the time is not being pulled in - only the date. So i went to the source excel sheet and extracted the into a separate column. I used the =TIME(HOUR(G2),MINUTE(G2),SECOND(G2)) and…
-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
If checked subtract using a date, if unchecked subtract using another date
Good afternoon, I am trying to create a day counter that will be counting until another date is filled. I thought nesting if formula's would work, but so far I am not successfully creating the correct formula. A screenshot below will hopefully help and here is the formula I wrote that is giving me the "Incorrect Argument…
-
Automated RYG Based on % Complete Formula Help
Hi, I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula? When I…
-
"IF" formula using dates and check boxes
I am looking to set up a count to see how many people are scheduled for an appointment verses how many have come in. I have an appointment date column and a check box that is clicked when someone comes in. I want this to be a summary formula not a cell. Could someone help? What I messed around with was…
-
Sumif matches criteria from multi select dropdown
Please help, i want to sum the Time Required in case the Week Number column has 1 and update Status is Monthly. I used this below formula but its not working. SUMIFS([Time Required (Hrs.)]2:[Time Required (Hrs.)]6, [Week Number]2:[Week Number]6, HAS([Week Number]2:[Week Number]6, "1"), [Update Status]2:[Update Status]6,…
-
Help with a formula
Hi! I'm having trouble figuring out a formula for the following situation. I have a column called "date applied". I want to know how many candidates applied per day. I also would like to add to that more filters I.E. location. Meaning I want to know how many candidates applied PER DAY PER LOCATION. Similarly I have a…
-
Levels formula
Hi all I am new to smart sheets, and I was after the formula for Levels and cross-referencing % to give a result. I have the following code in levels, but I need this to be more intelligent. =COUNT(ANCESTORS()) This returns the Uppermost parent as 0, Next level as 1, last level as 2. Is there a way of looking at the %…
-
Help with if max collect formula
Hello, Sorry I know there are already questions on this but I'm not getting it. I have a column [Users] of duplicate users, and a second column with unique numbers [Row ID] In a third column I am trying to get "Ignore" or "Select" based on the highest number per user So in the example above the PCUK832 should say ignore…
-
Cell Linking
Is there any way to stop a cell link from updating at once it has been populated? I am using the INDEX/MATCH formulas to assign a person to a task based off of a state assignment list. Once the task is completed, I do not want that person's name to change, even if the state assignment changes in the future. Any help is…