-
Added IP Management Functionality
Any Chance of adding this type of Functionality to Smartsheets: https://www.codeproject.com/Articles/712335/Followup-DNS-Lookup-and-Ping-in-Excel
-
Predicting a Date based on what type in as I complete a step
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. The expected completion date will move up or down depending whether or not I finish the task on time or a few days earlier.…
-
Sheets Last Modified
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 trying to gather all those Dates and Times to get the most recent change in multiple sheets. However, upon linking them and…
-
If Statement Help
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", "0137cc9c-51b4-40fb-bf06-73174c348733") I have 6 total stages but can't seem to get this to work. Any advice? Geneva
-
formula for the %completion in parent
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 inherently? The project guys always think they are further along on the project than they actually are and this is artificially…
-
Formulae help....new to Smartsheet
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. When a cell is ticked it means that the work has been complete etc. Any help/advise would be greatly appreciated.
-
Static Cell References
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 do a report and show the "top 10" vendors, or a pie chart, but could not get those options to work. So, I wrote a formula…
-
transfer a line from one sheet to another when a certain criterion is met
I want to transfer a line from one sheet to another when a certain criterion is given. how can i do it?
-
Sumif Circular reference
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 "[Assigned To]2", and for row 3 it would be "[Assigned To]3", etc. using this formula =SUMIF([Assigned To]:[Assigned To],…
-
Stop counting months when a completion date has been met
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 program. I'm working with "Status Code,", "Enrollment Date," and "Date Licensed/Dropped" columns. I have this column set up…