-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
Formula just stopped working
I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is =IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row ))) but instead of returning the value it says #INVALID COLUMN VALUE Got it working…
-
Date and Time Separator Formula
Hi Community, I'm looking for assistance with creating formulas in Smartsheet to separate a combined DateTime value into two distinct columns: one for the date and one for the time. "Date" Column: Contains both date and time values "Date Only" Column: Should display only the date "Time Only" Column: Should display only the…
-
Unique + COUNTIF Formula, Need Help
Hi all. My team is currently using a sheet to track tasks and hours spent on each task, for each week of the month. There are 4 different types of tasks (Project, Initiative, Ad Hoc, Daily Task), and some of out project managers work on the same project or initiative. I am trying to create a COUNTIF formula to count the…
-
I occasionally get #ERROR results from formulas that are only fixed by a page refresh
Occasionally I have been getting #ERROR or other error messages as a formula result in cells that previously return a valid result, and nothing related to that cell or the cells that are referenced changed. The only thing that finally fixes this is to do a hard page refresh. The attached images show this, and the only…
-
I don't understand my Sheet Summary formula
I've been using sheet summary formulas for a week but have been struggling with something I don't understand all afternoon. I have a summary field called % Planned Complete. For simplification, I'm testing this formula: =INDEX([% Planned Complete]:[% Planned Complete], 21) * 100 But it won't return the value for row 21 in…
-
Has anyone used remote staffing (like CrewBloom) to support Smartsheet workflows?
Has anyone here used remote staffing support (like CrewBloom) to help manage Smartsheet projects more efficiently?
-
Reaching Cross Reference Max error prematurely
I Saved as New an existing Project Metadata sheet with 90+ cross-references. When I removed the old cross-reference formulas. I was only able to add 6 new cross-references before getting the "Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references"…
-
Need Help with Multiple Criteria
I need a formula that looks for the a specific person in the Ball In Court column, then look at specific status in the Comment Status column and then look at another column and if it is blank return the number. I am not sure on what this should look like for the last column.
-
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…