-
Append Text before Formula
I have a formula like below: =ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0) How do I append "ETA Week Number" before the result of the formula. I have tried the below, but it comes up as UNPARSABLE =“ETA Week Number “ + ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0)
-
Auto-number across multiple sheets?
I have three sheets that auto number, assigning a sheet specific prefix, a counter, and a year suffix. So on sheet one I have "New-XXXX-2015", on sheet 2 I have, "Existing-XXXX-2015". I would like for the counter (XXXX) to increase upon each entry to either sheet. So if the first entry was "Existing-0001-2015", the next…
-
avoid the shared person delete my row
hi, i see some potential of lose of my data if shared to others. for example, my project schedule shared to partnes and they have to update the status, since they are editor and they can delete my row accidently, how could i avoid from this issue to be repeated?
-
Reports and alerts
I would like to be able to have the alerts feature added to reports, this would be beneficial so my employees can create reports and have reminders sent to them. By doing alerts on the sheet level, the alerts are on for everyone in the contact list; however, not everyone wants to be reminded or notified. Thanks
-
Email alerts with entire discussion
How can I get a "right away" alert that contains the entire discussion as opposed to only the last comment?
-
How do I use a wildcard or "contains" in my if formula?
For example, the cell reads "Smith, Johnny" and I want to write a formulat that returns a result if the cell contains "John". Normally I would use =if(cell,"*John*","YES","NO") with the wildcard * before and after John. But this does not seem to work in SmartSheet. Do I have the syntax incorrect? Thank you!
-
Can you make reports from reports?
I'm trying to flither information from one report to another and combining certain information. Is there a way to do this without starting with a new report?
-
Exporting to DOMO - columns being read as Text not Number
I currently have smartsheet connector to DOMO to create reports; however, the columns that contain financial data come over as text because smartsheet's column properties are Text/Number. Not Text, Number separately. Anyone know how to make this work? or a workarond? Thanks
-
Configuring Update Requests for entire sheet
I'm trying to create an Update Request on an entire sheet to send out a scheduled email reminder weekly. I am only able to setup an update request if I select 1 or more rows. Even when I select all the columns in the sheet, the ability to create a new update request is greyed out. I was able to configure this on an early…
-
Alert User in Row if Date has Past Due and not Complete
I would like to send an alert to the person "assinged" to the appropriate row the day after a "Due Date" IF a "Status" column has/doesn't have a value(s). For example, "Send 'Assigned To' and email reminder 1 day after 'Due Date' IF 'Status' does not equal 'Completed; Canceled.'" I want to target these communications to…