-
Convert into column formula w/o syntax error
Hello, Could you help me please ? I try to convert following formula into column formula w/o syntax error , unfortunately without success. Do you know by heart how I can do it ? COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row) Ty, Br, Tibor
-
Approval Workflow not sending notification
HI have an approval workflow that requires a notification to be sent to a user once the approval is done. The workflow has two conditions that split an approval process and subsequent actions, but both flows end with a notification step. The "Above R5000" = Yes" condition works perfectly but the "Above R5000 = No"…
-
Saving old templates under new name and workspace / Problems with the automation workflow.
Hi Everyone, I used an old production schedule and saved it as a new file in a new workspace. When I use the automation workflow to inform other shared used about changes, it keeps using the old name of the file. I erased the sheet and tried it again, but same problem occurred. Can anyone help to solve this problem please…
-
How do I set up reoccurring Update Requests based on a date in a cell
I am new at being an admin for my company's Smartsheet. I have set up a number of automations, but I would like to set up an automation for a reoccurring Update Request to be sent out starting 60 days prior to a date in a cell. I have a Start Date column, which have different start dates. I set up a Date Formula column to…
-
I have a question about the numbers not reflecting fully in my sheet when I add a decimal point
I created a Smartsheet form for getting data from my team members. I added a filed in the form to add a Invoice number, but the invoice number has a decimal point in-between, for example it is 17723533.3218539. Now the challenge that I am facing is that, when this number populates in my form, it is viewing as…
-
Sheet management question
Hi, Is there anyway of 'latch' two columns together? I need one column to allow numerical inputs (a) and one to contain dropdown entries (b). I want (a) & (b) to be side by side and if I move one column left or right I want the other to move as well to keep them together, ie if I move a, b will also move. Thanks
-
How to view a list of workspace attachments
We are attaching some documents to a workspace that are not specific to a sheet. However, there is no way to view the "list" of items that have been attached within that workspace folder. Is there a way to see these items without having to click on the paper clip? Users would not know there are attachements there unless…
-
Keeping track of original data after changes are made
Hi, I am using a form to send to employees when items are missing. They will have the ability to update the form which directly updates the sheet once they have resolve issues. I want to be able to keep track of when they have issues so we can use later for training. How can I keep a record automatically of the items that…
-
Sheet picker does not show any results for copy/move row automation set up
Hi Team, I am not able to see any results when I try to search the destination sheet using sheet picker for copy/move row automation set up. I have raised it to smartsheet support but they are giving links to usual set up. Can somebody please help me with this?
-
Report using quarters
I would really appreciate if someone could please advise how do I create such a report- we use quarters instead of dates (not specific in our industry, as in- we cannot provide specific dates) for product timelines. I would like for the report to automatically pull data from project data sheet and if possible also apply…
