-
workday calculation with if conditions
Hi, I'm trying to add a workday function to my current calculation. I already use if condition in the cell. Here's what I have. If location is Riverside, then add 3 days to ETA. If location is Memphis, then add 5 days to ETA. IFERROR(IF(Location1 = "RIVERSIDE", ETA1 + 3, IF(Location1 = "MEMPHIS", ETA1 + 5)), 0) However, I…
-
Can I sort entries in Card View?
I have a task list organized in Card View, with conditional formatting to highlight critical tasks. Can I sort them in Card View to list the ciritical items first? Thanks, William
-
Need Formula to auto populate todays date when box checked
Please share the formula that will auto populate the current date or "Todays Date" in the Completion Date column when the checkbox is populated in the "Done" field.
-
Adding Positive Parents
Hello all, I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive. Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed to add all positive…
-
Can you assign muliple resources to a task without duplicating the row?
Currently, I am having to list the same task on muliple rows to assign different resources to them. Is there a way to assign mulitple resources to the same task without having to duplicate the tasks over and over again? There is a lot of repetitive content that is doubling the size of my Smartsheet.
-
Send a Form as PDF attached to an email
Hi, Could we have a form generated as PDF in Smartsheet and sent by email to a specific user (email address)? So this user could fill it and send it again. I checked we could have the form sent as link by email, but I need to know if it is feasible to transform it to PDF and send it by email. Any suggestion or solution?…
-
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
-
Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")…
-
[Need Help] Non-License user can hide column but can't unhide?
Hi, I understand that only License user can hide or un-hide column in sheet they are admin. * Hide/unhide columns (also requires Sheet Owner or Admin access to the sheet) But we have some user (non-licensed but part of our Business) that are able to shrink a column in a sheet they are admin, but they are unable to unhide.…
-
SCC Nesting Summary Data
Is it going to cause any issues if I nest (indent a couple levels) data inside a sub-category, inside of a main category? (see attached img)