-
Notification emails going to additional wrong people
I have a sheet with conditional check boxes based on who is selected in a dropdown list. Notifications are set for the relevant person to receive an email when the box is automatically checked. All entries are made by a web form. Problem is that SS is sending the notification to additional people (from the drop down list)…
-
Report limits
Is there a limit to the number of sheets that I can have a report pull data from?
-
Allow inline editing from the attachments tab
Allow inline editing from the attachments stab instead of having to download the attachment so that is NOT read only, make the updates, save and then upload the new version. Saves a lot of steps if you have the ability to edit the documents right within the attachments tab.
-
Conditional Formating : Done/Status based on items below it.
I am using a sheet to tract information being sent by candidates. Is it possible to make the Red Dot in the "Done" Category next to "Candidate Name" Turn Green automatically when all lines associated with it are turned to green/done. I've been trying to get conditional formatting to work but I can't figure out what the…
-
Report for when a column has been modified in last X days?
Hi all, starting with a sheet that includes all marketing tactics for all of our projects, I'd like to build a report that rolls up every row that has had column "Designer" modified in the last X days. Is that possible? I can't figure out how to do so. I cannot add any formulas or conditional formatting to the master sheet…
-
Round up & If Condition
Hi, Hope this message finds you well. In Ms Excel, we have following function available, how can we have the same in Smartsheet? MROUND(AVERAGE(V2:Y2),0.5) Moreover, need to implement the same formula in smartsheet. IF(OR(AA2>0,AB2>0,AC2>0,AD2>0),"C","NC") Thanks in advance :)
-
Adding checklists to a project
In my project with gant chartsd and ependencies, I would like to add a task, e.g., "Set Up Vendors". As a subtask, I would like be able to add 10 vendors. Ideally then, as each vendor is setup, I want to "checkmark" each vendor. Once all 10 vendors are checked, then the task can be marked as complete. Is this possible?…
-
Is the site down?
Looks like this is the second time in a month there's been unscheduled maintenance.
-
PDF exported report includes comments even though not indicated
Hi there, When trying to export a report I built as a pdf I keep on getting the content of the comment column too even though I have left the box for this option unticked. What can I do so the report exports into pdf without this column? Many thanks, Lesley
-
Sum Children() If Date <=today()
I'm trying to create a fomula that will sum the TOTALS column for all the Children() of a parent row that the DATE <=Today(). Any thoughts?