-
Formula to copy the information of one cell into a different cell
Is it possible to use a formula to copy the information of one cell ( In this case the cell is under a date type column) to another cell (also a date type column) . For example, if my cell #1 under columnย "concept start date" is: 06/19/19 then automatically my cell #1 under column "Start" would automatically fill up asโฆ
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Flag out of Range Date
Hello, I have a date range: Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End. Can anyone help? I've tried: =IF([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completionโฆ
-
Cross-sheet references
I'm getting the error code #CALCULATING,ย which I think is because I must've gone over the 25,000 limit for cross-sheet references. The sheet originally had upward if 4500 rows and I've removed more than half of them now but I'm still getting the same error. Can anyone help with this please?ย
-
General coding/formula questions
When coding issuesย get beyond the incorporated realm of Smartsheet, such as in my recent post about time/date stamping,ย it is my understanding that Zapier, Smartsheet API, or compatible languages come into play. So, what are the opinions in the community about this. Do most folks incorporate a conglomerate of apps or stickโฆ
-
Formulat to populate a "modified (Date) cell" after a dropdown cell has been populated with "non bla
I am trying to populate a "modified (Date) cell with today's date and time stamp (date only needed) only after populating a dropdown cell with data (non-blank). I've tried NOT(ISBLANK), but to no avail. The dropdown cell is used as a status cell indicating i.e., "complete", "needs follow-up", etc. The modified (Date) cellโฆ
-
COUNTIFS with reference to another sheet more than one criterion
I'm very confused about this function. It has an #UNPARASABLE error. =countifs({Jade2_BCM Dashboard 2019 Range 1},"Complete",[{Jade2_BCM Dashboard 2019 Range 2},"Business Resilience",{Jade2_BCM Dashboard 2019 Range 3},"1st Quarter") I am trying to reference three columns fromย another sheet, Jade2_BCM Dashboard, to see howโฆ
-
Summing VLOOKUP results
Hey community, I'm creating a way to judge submissions, where each judge has their own smartsheet (so they can see/edit their own markings but not be influenced by others). I need to be able toย know (1) how many times a submission was judged, and (2) what the total score is on one single sheet. * Currently I've drafted theโฆ
-
Formula for cells with multiple assignees
Hello, I have a projects list that allows multiple people to be assigned. What is a formula I can use that will count someone's name when a cell has their name plus other(s)? Thank you in advance. Formula will be used as a basis for a dashboard
-
IF Error needed????
it works if there is data in the fields but if the fields are blank - it gives me the #incorrect argument =IF([*DEPLOYED Y/N/Daytime]564 = "Yes", "Green", IF(AND([*DEPLOYED Y/N/Daytime]564 <> "No", TODAY() < [*Scheduled Deployment Date]564, "Red", IF(AND([*DEPLOYED Y/N/Daytime]564 = "Daytime Deployment"), "Yellow"))))