-
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)
-
MS Teams & Smartsheet
Hi all, I've noticed that when using the MS Teams desktop app I'm asked to log into smartsheet each time I want to view the tab, I click on log in and nothing happens. This only occurs with the desktop app, the browser MS Teams app works fine. Anyone else had this issue (screen grab uploaded)
-
Jira Connector - Start Up
Hello! Has anyone in the Smartsheet Community had any success getting Jira Connector up and running without the Launch Package? I reached out to our Customer Success Manager for assistance in getting the application up and running and was told I needed a Launch Package (i.e. you have to pay more to use the feature you paid…
-
Adding a new Column to multiple workbooks
I have used the same template to create a tracking system throughout our company and now have 25 sheets. I have been asked to add a column to the template and all existing workbooks. Does this need to be done manually one at a time?
-
Approval Automation Question
If an approval request has been declined. The next step is to ask for an updated revision via request an Upate. Once that is complete I am sending another approval request. I would like the same column to be updated but it looks like I have to create a new column... Or Save Status as Value? Where is that I am looking for…
-
Use Countif to count the number of tasks assigned to a worker?
Hi, I'm sure there is a quite dimple solution to the this, but I am having trouble. I want to count the number of rows assigned to each contact, and I used the formula below: =COUNTIF(Assigned Work:Assigned Worker, "contactname") The formula returns the error #UNPARSEBALE How can I fix this?
-
Conditional Notification on two Predecessors
I want to set up a notification to begin a task when the predecessors of the task are completed. The tasks in question have two predecessors each and I cannot for the life of me figure out a way to have the completion of those predecessors trigger an alert to the people assigned to the tasks so that they can begin work.
-
Linked Sheets for Templates
I believe this is an enhancement request but I see it is always good here to start the conversation in the community to test the appetite before requesting it, and it seems it gets picked up by staff more here. I am creating project templates in smartsheets for our project managers. I am doing this by creating a 'Master'…
