-
Trying to get a formula to work
I am currently trying to get a formula to work in Smartsheet that will count the requests we have outstanding that havent been completed and are over 41 days old. But that will also take into account when new lines are added to the document. The formula I have got working in excel is: =COUNTIFS(B:B,"<"&TODAY()-39,C:C,"")…
-
RYG Balls Default to Yellow if Due Date is Blank
Hello! I have the RYG balls working great in conjunction with a "Complete" check mark and "Due Date" ranges. However, I cannot seem to figure out how to apply the forumla to the entire column without seeing a bunch of default yellow balls if the row does not have a due date entered. Is there a way to hide the balls all…
-
Two Separate Date Fields into one sum
I need to give per diem to employers for days worked for two events. Some will work one, some will work both. I have a formula that works great if they are working both events, but get the #MISSING OR INVALID PARAMETERS" message when only one event is worked. Does anyone know how I can get a column to return a "0" date?…
-
How do you Set-Up Reoccuring Tasks?
Hello! I am new to Smartsheet and I am trying to take all of my tasks listed in Outlook to form my personal Sheet for my schedule. I have many tasks that I repeat weekly, is there a way to form these in the sheet? I do not want to have to list the tasks every week, I will if I need to but wanted to see if there was a…
-
Amount of Working Time Between Tasks
We have a desire to calculate the amount of work time between the end date of a task, and the start date of it's successor task. Before the update that included partial day durations, we were performing this with simple date arithmetic. Now, that arithmetic does not hold true, and we need to devise an updated formula to…
-
Multiple IF formula
Hi I am unable to figure this out. I need a formula that says: If any of the cells Barcode:Barcode contain the term "1 In Production", then add the text "In Production" to corresponding [In Production]1" cell.
-
Macro like functionality
Is there any method planned that would enable a change to trigger other changes. For example, I'd like to be able to cut out a step in one of my sheets whereby if I mark a task as complete that it would automatically change the % complete column to 100 (and vice versa).
-
Count specific list items in child
I have a list of reports being sent to specific users as seen here: Location 1 - User 1 xxxxxx -- Report 1 Monday -- Report 2 Thursday -- Report 3 Daily In the "xxxxxxx" cell, I'd like something like this: M:2 T:0 W:0 T:2 F:0 to let me know at a glance how many reports someone is getting on daily basis. I can't spread the…
-
Help with an IF statement
Hi guys, I'm in need of some help with regards to trying to use an IF statement to manage Priority rankings. Basically, i have two columns that rank boht Criticality and Manageability, dependant on the score obtained across boht of these dictates the Priority ranking applied to a Risk. I'm currently receiving an #INVALID…
-
Report based calculations
I would like to be able to have a calculation take place in a report that is based on numbers in cells from two different spreadsheets. Any ideas? Not keen on linking for this application as that would require multiple linking of new data, which would have a higher probability of user error.
