-
Merged: New Column Type: Time
This discussion has been merged.
-
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
-
Calculating Next Monday, Wednesday, Friday
I'm trying to write a formula to calculate the next monday, wednesday, and friday following a particular date. The AI formula generated =IF(ISDATE([Start Date]@row), [Start Date]@row + (8 - WEEKDAY([Start Date]@row, 2)), "") using the example above; however, it generated an #INCORRECT ARGUMENT error. The expected results…
-
Formula to bring back the 3rd Friday of next month
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence. Any help would be very appreciated! Thank you.
-
Locking in results from a formula
I have a sheet that each ROW is a monthly store visit. I have a column that counts the number of visits each store has and add that number to a unique store visit ID…. example Store 123 visits= 3 then the store visit ID would be: store123-3 Every thing has been working fine, it is great because you can always tell how many…
-
Compare data from two sheets
Hello Team, I would like to know if it is possible to use the Automation in Smartsheet to compare the data in two sheets. Basically we use Smartsheet to manage devices and we have 2 sheets, one for Production devices and one for Lab devices. Since we manage a large number of devices, we need to find a way to continuously…
-
Inventory Check In/Check Out with Forms
Hey Everyone, I'm looking for how to automate a check in/check out process utilizing forms. What I want: Tech fills out form with the item's serial number and checks a box for if they're checking in or checking out This creates a new row in a helper sheet (CHECK OUT) A master inventory sheet (EQUIPMENT) update's the…
-
How to calculate NPS Score from Smartsheet Sheet
Hello, I have tried to calculate our NPS score, but am getting either UNPARSEABLE or 0. What am I doing wrong here? I've tried this formula (NPS Score 1): And this one (NPS Score 2):
-
Formula for Cross-Sheet References Based on Row/Task Information
Is there a way [in the Core App - without Control Center] to create a formula that pulls in data from another sheet via cell linking, but is set up in a way that it can be used in a repeated use template? To give an example of what I'm trying to do: I have a set of projects that are fairly consistent as far as activities.…