-
Autogenerating a report to send to an email recipient
From a report, I would like to auto-generate an email for a new row added. Victoria
-
Sumif /Sumifs
Having trouble getting the sumif function to work. I have tried 2 versions, below =SUMIFS([Days Open]:[Days Open], Location:Location, [Repair Description]17) =SUMIF(Location:Location, [Repair Description]15, [Days Open]:[Days Open]) The [Days Open] is a number calculated by subtracting 2 dates (the cells with functions)…
-
Flagging Red using two conditions
Desperately trying to find a formula that does this: if due date is past and checkbox is blank then flag red in Symbol column For Row 15, tried this but it is not parseable. I used this formula in the Flag column =IF(AND([Checkbox]15 < 1,TODAY()>[Finish]15)1) says UNParseble
-
How to lock/unlock sheet in oder employees could modify it withing the given time frame?
Hello, I would appreciate your help to my question! :) Every month different teams need to input the information in a sheet within a given time frame, after deadline all information is extracted to pdf and shared with the rest of the company. Many often employees are changing information after deadline, which means that…
-
excel doesn't recognize text/number column from smartsheet
I've linked an Excel worksheet to a Smartsheet report it works fine but one column that has a numbers and text (p.i. 4551A) is imported blank (no data). When is a regular number imports it just fine. Does anybody have any idea what could be the problem? Thanks, Herb
-
new feature on engage conference:approval request
Hi, I have difficulty to understand new feautre of approval request. I am a property management company and every month need to upload financial report to client web site. Accountant create financial report, then account manager need to approve, after account manager approve, client approval, them mail room will mail…
-
Update Form Not Working
I have confirmations from two weeks ago that I updated the Smartsheets through an update email that was sent; however, my updates don’t appear. My staff said that the form that pops up on the email that is sent doesn’t work so they have to update changes directly on the sheet. Is anyone else experiencing this?
-
Sight
What workarounds to we have to put an Excel Chart on a sight. I have tried to copy/paste into Paint and save as a picture, then used the Image Widget, however, although the chart is displayed, it is very small and not readable.
-
Notifications
Within Alerts & Actions, I know how to send a notification to an Email Address within a specific column of a sheet via the "Contact in column" and selecting the column. That is working great. My question is whether I can send this notification, with a CC to me. I know I can clone the original notification and send it to…
-
Prevent column name from showing up in Sight
This topic has been discussed before, but, for whatever reason, that discussion is frozen. When using the metric widget in a sight every selected cell will get the name of the column it's in as a passenger. While I can't find any reasons for this approach, it would be nice to have an on/off switch. I know one can remove…
