-
Formula for populating date
I am needing a formula that calculates Termination Date (date property). The formula needs to look at Initiation Date (date property) and Term (text/num) which is based on # months, to calculate Termination Date. In this example, the termination date should return a value of 1/01/26. Thank you!
-
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
-
Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
-
"Rolling" cleared text - how to manage
I have a sheet that others update as and when they can as well as reporting by set dates. A checkbox is used to mark that the material is cleared for reporting and this is the criterion that pushes the information through to dashboards and paginated reports. Managed previously with a single checkbox that was cleared on a…
-
Text to different Rows - Split by delimiter.
Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?
-
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
-
Re-write a formula to make it Column Formula compatible
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…
-
Can I use a sheet to create a purchase order form?
I'd like to create a purchase order form that allows users to select items from a drop-down list and display the quantity and total of each item. I have created a sheet, but all of the items in the primary column do not appear as a dropdown.
-
How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
-
Reference links break in formula
I want a formula that can reference updates on another sheet and add the info onto my sheet. The other sheet is a schedule that has job locations and PTO time for each individual on each day of the week. I want to know the dates that each individual on the sheet has an upcoming PTO, and for my sheet to update with 'PTO' on…