-
Sumifs
Does anyone know how many criterion you can have with a SUMIFS? This formula works =SUMIFS([Conversion to $US]$21:[Conversion to $US]$385, [Cost Centre Description]$21:[Cost Centre Description]$385, [Cost Centre Description]6, [Fiscal Year]$21:[Fiscal Year]$385, [Fiscal Year]6) But when I add one more criterion such…
-
Autofill compliance
User Mgmt: I have users entering data into a sheet. They are not always inserting lines in a manner consistient with Autofill and some formulas in hidden columns are not filling in, "breaking" the sheet. Does anyone have any strategies for making sure people follow rules that allow autofill to complete? I have trained ad…
-
Security loophole
We have a sheet containing sensitive data in several columns. We limit the visibility of this data by hiding the columns, so only Admin users on the sheet can unhide/view the data. However, any Smartsheet licensed user, including those with only Viewer privileges, can circumvent the sheet security by simply saving the…
-
Adding groups to existing groups
Is there a way to add groups to existing groups to create a sub-group hierarchy? Google apps for work has this and it is very convenient. If it is not an existing feature, I think it should be. An example where this feature is helpful is for creating a group for an entire company where each entry is another group that…
-
Working examples of Smartsheet in Order Management & Production environment
Hi There: I'm implementing Smartsheet across a client's furniture manufacturing environment. I'm new to SS but have been diving in deep since the beginning of the year. However, I'm still struggling with particular case use with respect to managing the workflow between different departments involving both physical and…
-
delete rows by employee to avoide tasks completion
all i need my employee to do is click the button and change the status of the job. i have tried giving view access but they can not click the button to update the status to change it to done or compelted i have given aceess as editor and admin, but then the task can be deleted by empployee the reason i am trying to buy the…
-
IMPORTS
CAN I IMPORT INFO FROM OUTLOOK CALANDERS TO SMARTSHEET.
-
numbering child rows
I have a sheet I've been using for a while. I just added a column and set it up to auto number. All the rows increased sequentially, e.g. 1, 2, 3 etc. The child rows, and their child rows continued in orer, in otherwords the child of parent row #1 was #2. I'd like the child of Row #1, to be 1.1 or something like that. Be…
-
Visual misalignment of highlighted row
Does anyone know how to get rid of the visual misalignment of a highlighted row on the screen. I am usually using Smartsheet on Safari. I tried to attach a screen shot of the issue.
-
Can you make reports from reports?
I'm trying to flither information from one report to another and combining certain information. Is there a way to do this without starting with a new report?
