-
Scheduling an Update Reminder like an Alert
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and every time; keep in mind I…
-
App notifications
Maybe I'm missing it, but is there a notification that can be sent through the app when web form is submitted?
-
Report Builder - Pull projects completed one year ago (month)
I would like to auto-run a report of projects completed over the course of a month one year prior. (i.e., the report would tell me on August 15, 2017 what projects were completed between August 1 and August 31 last year). I plugged in report builder that the column I want it to filter by (Actual Completion Date) should be…
-
Sum values from a report
Hello, I have a log sheet that records a project name, resource and hours, with many rows of entries. I would simply like to create a report that sums all hours by project. I don't see how this works in the report function, but it seems like it should be doable. Any help would be appreciated. Nick
-
Consolidated SmartSheet
Hi all, I am pretty new to Smartsheet and in need of some help. We are using smartsheet for an upcoming budget task. I have created over 50 different sheets. In each sheet there is a column with checkboxes. I want to have a user check the box when the specific task is completed. My question is, is there a way to create a…
-
Auto-Copy Formulas
I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, it seems to work. I noticed this, because all of the IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else…
-
auto refresh
Is there a setting for auto refresh. What I have been running into is when I go to use the next available row....for instance row 5, a coworker can be entering at the same time in that row without my knowledge. I then fo to refresh and everythng he put in is mixed int o what I put in. It may have the adress or lacation of…
-
When Sharing, Message Loses Paragraph Breaks
When we send a message to users while sharing a sheet, the email used to display the carriage returns and paragraph breaks. Now, it lumps the sentences together and they look like run-on ideas. See screenshot. Is there something I'm missing?
-
Task text disappearing when highlighted for a few seconds
Has anyone seen task text disappearing if you keep cursor on the field for a few seconds? There was an discussion created for this issue in the past and was resolved due to caffeine application. I do not have caffeine installed. Any help will be appreciated?
-
Send update request to a 'group'
Hi All, new to smartsheet so apologies if this has already been asked but still finding my feet. I can see I can send a mail to group from the row but I want to be able to send an update request to a group, if a member of the group updates and sends a comment then I can see that it was updated by Steve@... I have tried…