-
Avoiding #INVALID DATA TYPE when cells are blank
Hello, I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message. There are 2 formulae set up within the sheet: Leave Remaining (the dark grey row) is calculated as follows: =[Leave Allowance] - Taken + [Leave Bought] + Carried + [Long Service] Taken (the…
-
=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) Formula help!
Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines under the parent row, but don't want them to count toward the total shown at the top. Is there a way to do this?
-
Bring Task to a separated Smartsheet if due date
Hi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks that are about to get due. How can I do this? Thank you
-
How to combine multiple excel sheets in one smartsheet?
Hello, I am trying to create one master sheet in smartsheet. I have 10 excel sheets with identical column names. I have created one master sheet with the same column name. How can I combine all those sheets in one smartsheet? Is there any way to copy and paste columns in smarsheet? Please help and let me know all…
-
Column Formula Question
Is it possible to convert a cell formula to a column formula if it references a different sheet? Here is the formula in question: =VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false) Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet.…
-
Include Column Description in Update Request Form or Form to Update Existing Rows
It would be incredibly helpful if the column descriptions were included in the update request form. We will request information from users who do not have access to the sheet and likely will be unfamiliar with the type of information that should be included in the column. Forms allow help text, this should also be a…
-
How to add multiple IF statements to WORKDAY function?
Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have =WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49) I want to add 2 more cities. The function can either be from another column/sheet that has the…
-
nesting properly?
Hi all and good afternoon, im working on a sheet that seems to be giving me an issue and I am aware its my lack of knowledge. Hopefully someone from the forums can give me some insight as to how to achieve my desired result. I have a cells contents with: =-SUMIFS({Transactions Range 1}, {Transactions Range 4}, ="Issue",…
-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…
-
What new features do you want to see in Forms?
Hey! We run a form-building service at FormCrafts (https://formcrafts.com/) and have been considering building a native integration for Smartsheet. I'd love to get some feedback and suggestions on what people are looking for that's missing in Smartsheet forms. Some ideas we have so far: Being able to add custom text,…
