-
Any idea what I could be doing wrong?
Hi all, I need to create a formula that will collect info from a different (original project) sheet and display the right data on the cell of a new sheet (used to build a report) - that way things stay updated as the project progresses. So, a couple of things need to be taken into account, the info displayed needs to meet…
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
Trying to increment a value by 1 each day, based on a specific status. - GOV
Each day that a row is in an 'In Progress" status, I want to increment a counter to determine the # of days in progress. So far I have tried an automation that runs daily and filters based on the condition. But I am not finding a way to add 1 to the counter. I have thought about doing a function but can't find a suitable…
-
Highlighting Past Due Items for Different Dates
I’m looking for a way to highlight when a date exceeds 5 business days without explicitly setting due dates. For example, if I enter a submission date as 2/3, how can I automatically highlight it as past due on 2/10? Any suggestions on how to track this in Smartsheet? Each line has a different request with different…
-
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!