-
Countdown from today not working
I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't really helpful for me. I have turned on and off the duration function, it gave me a…
-
Formular to show tasks marked 100% in past 7 days, 30 days by user
Hello, I am trying to add formular to sheets to show the tasks that have been marked 100% for each user in a certain time period, ie past 7 days, or 30 days etc. This data will be shown in a widget on our report page for team dashboard. Glad of help
-
RYG with vlookup
Hello, I need my sheet to lookup an employee's id number on a second sheet and return a RYG ball depending on the code in the 8th column. I tried this with no luck: =IF(VLOOKUP([Employee #]1, {EIC Range 3},8,False)="Yes","Green"),if(vlookup([Employee #]1,{EIC Range 3},8,False)="Not…
-
Formula help please
Hi, looking for some help please. I want to count a financial figure when the status is not received. Columns i am using are Start up budget and Received status. Probably really easy for someone, but am struggling with formulas as quite new to Smart Sheets. Any help greatly appreciated. Thanks Dave
-
Sum If formula question - Don't want to sum if it's a loss
Hello! I'm currently using a Sum If formula that works to sum up by each lead, however, once we turn the Sales Stage to Loss I would like to remove the losses from the sum for that person's weighted forecast. The formula below is filtering to just sum up the weighted forecast for John Smith but I want to exclude anything…
-
Invalid data type/unparsable for date countdown
I'm trying to have an automatic countdown but I keep running into an invalid data type or unparsable error. I am trying to show how many days remain until a point in the future (07/17/2018). Here are some of the formulas I've tried without success: =NETWORKDAYS([timer start]1, [Minimum billing date]1) =[Minimum billing…
-
IF Statement and Health
I am trying to use the following IF statements for my health column. I get up to IF([Move Complete]@row = "Termed? ", "Red", and if I add any IF statements after that it doesn't work. Can anyone tell me what I am doing wrong in this formula? =IF([Move Complete]@row = "Yes", "Blue", IF([Move Complete]@row = "Termed",…
-
Month not displaying correctly
I have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11:39 AM and the month column returns a 3. The formula I am using works for every…
-
How to count within a date range in first column and with a specific criteria in a second column
I want to figure out how many times a specific person sends an application out within a specific date range. Here is the formula I tried: =COUNTIFS(Name:Name,"Jane",[Application sent]:[Application sent],AND@cell>=DATE(2018,1,1),@cell<=DATE(2018,3,31))) Thanks ahead of time for any thoughts!
-
Auto Status Change/Update
Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create…