-
Linked Cell Format Issue
Hello everyone, I have tried looking for this topic, however, I can't seem to find anything. I have a source sheet with dollar amounts and the cells include a number such as $100,000.00. When I link the cell to a new sheet, the number shows up as 100000 Any idea how to fix this? Thank you. Sincerely, Diego
-
Resource View from more than one field.
As suggested by SS, I have a Assigned To field for a task lead (set for only one value allowed) and an Additional Resources field which allows more than one contact to be included. When I create a resource view, it seems like it is only pulling from the primary field and not the additional field. Anyone have a work around…
-
Cloudflare
Anyone else having issues with cloudflare when editing comments? Trying to fix some code i miss-submitted and can't change it. Basic stuff too, just missed some parenthesis.
-
If than statement
Hello, I need your help. I would like to use If statment in conjunction with symbols. The following is the statement that works only , got blank, green and yellow , but I cannot get it to work for red. =IF(ISBLANK([2019 Budget to Forecast Variance %]50), "", IF([2019 Budget to Forecast Variance %]50 <= 0, "Green",…
-
Automation Alert Someone Email subject
Hi all, Currently, when setting up an automated alert to someone, you can customize the message by entering the email subject/body. Right now, you can only enter free text in these fields. I was curious if you can set the email subject to fill in what was entered on an field on a form. I'll add a screenshot to clarify…
-
Attachment
I know on 26Aug19 brought the new Attachments in Right Panel logic. Question from a consistency perspective, is there plans to create this same look and feel in reports as well. At the moment, if you are in a Sheet, you see the new attachment logic, however, if you are in a Report, you see the old style attachment logic.
-
Multiple Selection on dropdown
Is the ability to select multiple items from a dropdown still in development???
-
Inconsistent Horizontal Column Alignment
Is anyone else experiencing a problem where new records entered into a Worksheet sometimes aligns the text horizontally at the top of the row, and other times at the bottom, or center?? I can't find any consistency in some of the columns, even if I've set the entire row to align top, or align center, or align bottom. Any…
-
Notifications for when something DOES NOT happen
Hello, We have an important task to do daily at my workplace, and I would like to set up a notification system if the task does not get completed. The idea is that an employee completes the task and then submits the form. If one form is not submitted for the day, an email goes out at X time to notify the supervisor. I…
-
Approval Request
I'm trying to set up a workflow process for OOO requests. I would like there to be Approver comments if the request is Denied but I can't seem to get it to work without having the Approver log into SmartSheet to enter the Approver comments. Any suggestions would be greatly appreciated. Thanks -Peggy
