-
Names in column brought over to Column titled after name?
Hello! Sorry for the confusing title. I have a sheet that users will manually input %'s into. The sheet has 3 columns, Task #, Names, and %. I basically want to send over the %'s into another sheet that tracks everybody's % based on the Task # and who's name is in the "Names" Column. Sheet 1 Sheet 2 So I want to create a…
-
Form not auto populating fields if one column cell contains a comma
I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating…
-
How to add only the $ Symbol without the currency in the PDF document?
Hi all, How can I make sure I can show the $ symbol in the PDF file without the currency? My columns shows the value without the currency: But once the PDF is generated it comes with the NZcurrency, which is what I do not want. Thanks in advance.
-
How to populate duplicate numbers into sheet?
Hello, I have one main sheet that tracks all incoming DRR #'s and every row has a couple of names in it. I want to build another sheet that tracks names based on the DRR # but want it to populate in different rows, like below. So two people are on 0001 while in the main sheet that would only be one row
-
Smartsheet Column Removing and Adding Commas
Hello, I seem to be having a situation in a column formula where it is adding and removing a comma every other hour. My Formula for this column is basic: =IFERROR(IF(Markets@row = "", "", Month@row + "_" + Markets@row + "_" + Model@row), "") The UID Column is the one in question. Markets@row is a multi select drop down,…
-
Flagging and Counting Consecutive Weeks of 'No Time to Report'
Hi everyone, I'm having trouble with a problem in Smartsheet. I need to flag instances where there is "no time to report" for consecutive weeks and count how many consecutive weeks this occurs. The two highlighted columns on the right show what I'm trying to achieve. Any help would be greatly appreciated!
-
Gathering data from 2 smartsheets into metrics sheet for dashboard
I am trying to take this formula and get the data 'CAD' from both smartsheets and place the amount of times in total that it appeared What am i missing in my formula? =COUNTIFS({Behavior Analysis: 1S Range 1}, HAS(@cell,"CAD"), {Behavior Analysis: 1SShop Range 1}, HAS(@cell,"CAD"))) Anyone have any suggestions?
-
Complex Lookup
I have a main table that, given the team(s) involved in a project, needs to look up the contact info for members of all of those teams. ([Teams Involved] is a multiselect dropdown, and [Members of Involved Teams] is a contact list where multiple contacts are allowed.) It is to get the list of team members from a lookup…
-
Sum formula not adding correctly
I am trying to sum up columns but its giving me an output of zero when the total should be 25. Can anyone help?
-
IF Formula
Hi I would like help on a formula to score time criticality. Ive tried the below but its coming up with errors. I also would like to add a formula that if there are any negative numbers such as -201 then this would show as "10" Formula i used below but not working =IF([Time Criticality]@row <= 30, "10", IF([Time…