-
Formula to return the Card view order
Is there a way to return the sort order of a card? Use Case: We use smartsheet for our intake. We have 4 areas that we sort requests into, and we stack rank requests in each of these areas. It's great that smart sheet will remember the order of cards, but we want to be able to always see the stack rank, aka the order…
-
How do I exclude closed issues from chart?
Hello Smartsheet Community! I have created a chart that displays all issues to date, but I need one that also shows only the open issues. How do I set that up in the metrics to display correctly in Smartsheet dashboard? The original reference is from a column with a dropdown that includes "Resolved/Closed" as a status. See…
-
Get a date from a week number
Hello everyone Do you know if it is possible to get a date from a week number information ? Here is the exemple : I have data structured in this format : 2020-13 (Year-Weeknumber) I would like to convert this data into a date, for exemple firstdayoftheweek/month/year. Do you know if I can set up a formula like this ? Thank…
-
update 1 sheet based on changing key
Hey there, We are a manufacturing company that are managing lots of different parts in smartsheet serials etc.. which are not always stay the same. we currently have 2 sheets on the same product which each of them is managed by a different person. We are trying to update 1 sheet based on the key on the other sheet, but the…
-
How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet!…
-
Counting cells with no blanks in a child column for multiple parent sections.
I have students(CHILD) categorized by University (PARENT) on one Smartsheet. I want to get the total number of students for that school in my sheet summary field. I was able to reach this with this formula. Here is an example of my Smartsheet: =COUNTIFS(CHILDREN([Schools]1), NOT(ISBLANK(@cell))) Answer: 2 which is CORRECT!…
-
Adding
Hello, I am looking for help in smartsheets. I use it for work as I heard it was just as good, if not better then excel. However, so far I find Smartsheet really hard to use and understand. I have been making budgets, chats, etc for a couple years in excel and I am pretty good at it. However, when I use Smartsheet I feel…
-
If Cell is not blank, equal date from different cell
I need the minds of the collective community! I am trying to create a formula that states: If "BCR Initial Approved Date" is not blank, then use date from "Estimated SFS date" or If "BCR Initial Approved Date" is Blank, leave blank. Attached is my attempt at creating the formula but it give me an Incorrect Argument set.…
-
Nested If Formula
Could someone please help me with this IF formula? Much appreciated! =IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual Miles]1 <=150), "Two", IF(And([Total Individual Miles]1 >150, [Total Individual Miles]1 <=250, "Three",…
-
Using a hyperlink with a comma in?
Hi, I'm trying to use a Vlookup to bring up a link to file when a part no is entered. Unfortunately Vlookup won't bring a hyperlink through when it matches a cell, just the cell contents. So I've created a second cell with the raw hyperlink. However I've run into an second issue where Smartsheet won't recognise a link past…
