Connie Cochran
Connie Cochran
Discussions
- I'm trying to create a formula that looks at the client's name and returns the event date but if the client's name is a duplicate the return only the event date of the first occurrence, but I am getti…
- I have a formula that is check to see if the event IDs are the same and if yes then return the total registration. The problem is that some of the event ID's look the same but are different due to cas…
- Tried to search but all the responses are old and I'm hoping that Smartsheet's has made an update. Can you send an attachment on an automated email through workflow without linking to the sheet???
- Formula to look at "Client Name" and if duplicate only return Yes for the first one, if not duplicate then just return Yes but I'm getting an error. Help? =IF(COUNTIF([Client Name]$1:[Client Name]@row…
- Trying to write a formula that says look at the Requested screening type(s), Month approved screening, Year of event and if they are the same as on the MAIN - Dont Touch Onsite Request Form sheet then…
- I know that currently Smartsheet doesn't have a time format, but I have a column with a drop-down selection with dates. Is there a formula that in a separate cell, can reduce the time by one hour?
- If I have a field with the date of 8/9/2023 and I want to add a column with a formula to find the date for the beginning of that week how would I write it?
- Is there a way to include an attachment in automated workflow email? I tried using the "alert someone" workflow and selected "Links to sheet and specific fields" and then selected "attachment" but it …
- Is there a way to update a date field automatically if a date is put in another filed? Currently we have an event date in the column, but I would like it to update if someone requests an alternate dat…
- I need a formula that says if the event date is less then 30 days from the date the record was created return the words "less than 30 days" but if its more than 30 days return the words "more than 30 …
