-
Use a blank "Column Name"?
Is there a way to leave the "column name" blank for a Smartsheet column? Or, alternatively, input a blank placeholder (character or otherwise)? Why? I don't want any words, spaces, symbols showing up in the Smartsheet Calendar app from this "column name" but I do want the data within the column to show up on the Smartsheet…
-
Count if cell has a number (not blank or text)
I'm trying to find a formula that will count a cell if it is a number (vs. blank or has text). My original formula didn't take text into consideration, so I'm starting with a simple COUNT formula: =COUNT([Name]8:[Name]58). I assume I need some kind of COUNTIF formula, but am not sure how to reference numbers in general.…
-
automatically sharing task data between sheets
Is there a way to create an "index" that will automatically link a schedule task and all it's information once it is entered in another smartsheet. For instance, let's say I have a meeting agenda and we want to talk about a schedule task, could I enter it's "index" from the schedule and have it automatically link all the…
-
Date formula
Hello, I need help with a date formula, I need to enter a date and once enter 10 weeks are subtracted from that date. New date will be displayed. Thank you.
-
First Monday of month start date in Project plan
Hi everyone. is there a way for me to have the system automatically find the first Monday of the month showing in the the project plan start date without me having to change it every month?
-
I would like to pull data from one smartsheet into another
I'm sorry to be asking this question, I've been struggling for several days. My background is sql against rational databases. In sql, I would like to join together 2 tables and grab the data in column Z from the second table when the values match in both tables on a specific column (not providing the value in the statement…
-
Formula to pull the non-blank value from multiple columns
Not sure if this is possible but I'm trying to pull a non-blank value from one of multiple columns and paste it in a separate column. Essentially, there are 5 columns that are Department (Deburr, Lathe, Mill), Deburr Machine, Lathe Machine, Mill Machine, and machine (think of this column as the master column, or…
-
Networkday formula with Cross Sheet Reference to Holidays Sheet
Hello! I'm running into a strange issue with my networkday formula. I'm trying to keep track of time off requests as they are submitted. The following formula was working for me as of now. =NETWORKDAY([Start Date]@row, [End Date]@row) However, I noticed that the count wasn't correct as some people were including company…
-
Counting 2 different Columns?
I am in need of some help. I can't seem to figure out how I am to get a count of how many people selected a certain salad with a certain protein. I have one column that participants are picking a lunch item. Two of those items are salads. I put the formula =COUNTIF([Sunday, January 23rd Lunch]:[Sunday, January 23rd Lunch],…
-
Index/Collect Formula to create a Cashflow by Month...
I'm trying to forecast a cashflow model internally, and I'm having a bit of a brain blank on this currently! The first sheet below details the Project, Total Invoice Amount and four separate payments due with the corresponding months and years for each payment. The second sheet details all four payments by the month/year…