-
Cell Time Stamp
Does anyone know if there is a way to get a Date to generate when a project is set to approved? I want to be able to set a target date using the time stamp from when a concept drawing is approved to when we will need to ship samples.
-
If no Array formula and no Sumproduct, what can I use?
I have been trying to create a product cost calculator where every column is a finished product and every row is a raw material. I am really bad with formulas but I had success with both Arrayformula and Sumproduct in Google Spreadsheets. But I need my data in Smartsheet and I can not calculate the cost of one product. Do…
-
CountIF formula for two different columns??
I'm looking to find a way to create a count statement if one column contains "a" and the other column contains "b". Example: If "Status" is "Open" and "Issue Type" is "Bug",then count # I looked to the formula example sheet for this but all I see in one that I believe would work has a "expand rows to see example" message…
-
RYG Balls connected to Whether Items are completed or not.
I am looking to connected RYG balls to whether certain items are complete or not? I am not sure of the best way to do this- if a checkbox would be the way to connect color change based on status of task, or if inputting a "completion date" would do the same thing? I tried a couple of different formulas from these forums…
-
How to use data from another sheet as selection criteria?
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?
-
Cross sheet formula - help
With this new feature I'm hoping I can eliminate abut 10 columns from one sheet and create a sheet just for totals. Currently I have several columns just for counting the value of columns with checkboxes. Do I have to leave these in the same sheet? When I tried to do the values in a new sheet by referencing the main sheet…
-
Referencing sheets
I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filter what is needed (to a point) with reports but it still doesn't give me the end result I need. Here is the breakdown in a…
-
COUNTIFS Statement Help
I am trying to COUNTIFS but have been unsuccessful so far. I need to count the status of a project if it is a certain product. I keep getting #INCORRECT =COUNTIFS(Status3:Status51, "Green", Product:Product, "Rapid Test") Thanks.
-
Status Balls formula help
Hi, I am very new to this an am getting a bit frustrated. I have the following columns, Ship Date, Fabric Order Date, Fabric ETA, and Fabric Received or In Stock. The first 3 columns are date columns and the 3rd is a checkbox. I would like my status balls to due the following: If Fabric Order Date is blank, I would like a…
-
Alerts & Actions
I am trying to ultimately set up my sheet to automatically send out Update Request 3 days (or whatever I set) within the "Bid Date" loaded into the sheet. It would be ideal if this update request would be emailed to the contact in "Sales Rep" column and copy (cc) me in the emailed Update Request for all of them. I was told…
