The first column are the dates I complete a task. The fourth column are how many days I have to complete the task. I'm trying to predict the completion date as I enter the dates in the first column. T…
Hi, I have a formula =MAX([Last Modified]:[Last Modified]) + "" for getting the most recent date in the Last Modified System Column to get the latest modification date is for the whole sheet. Now, I'm…
I have a column with 6 options and I am trying to create a statement in another column that says: =IF((Stage1) = "Opportunity", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9…
Hi All, I am trying to replicate the %completion formula in googlesheets in order to understand the value of a project based completion of the various subtasks. Does smartsheets have this ability inhe…
Hi everyone, I am a new user to smart sheet. I need to do a sumif calc based on two columns of data being 'unticked' so I want to show the sum of i.e Column D but only if Column A & B remain unticked.…
I have a list of expenses paid to vendors. The same vendor may appear in the list multiple times. I am trying to figure out a way to summarize all payments to vendors. I had looked for the ability to …
Hello, I know this is possible within Microsoft Excel, but do not know if it is possible within smartsheet. Trying to do a sumif formula across multiple rows and only change "[Assigned To]1" from to "…
Hello, I need to have a column that calculates time in a program from a start date freeze when the employee's status changes, it needs to keep counting as long as the employee is still "Active" in the…
I'm working on a sheet that will provide me with a team breakdown and weekly breakdown based on checkboxed columns (to make it easier for the end users of the sheet). However, I can't get my formulas …
