-
Company uses smart sheet in metro manila philippines
Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank you
-
Formula to assign fiscal quarter not working
Good morning, I have been using a formula to assign a fiscal quarter to a row based on a date in another cell. I realized yesterday that the formula isn't working properly. This is the formula: =IF(ISDATE([Estimated Ship Date]1), IF(MONTH([Estimated Ship Date]1) <= 6, "Q1", IF(MONTH([Estimated Ship Date]1) <= 9, "Q2",…
-
Webforms Colors and Logos
Our company owns multiple Brands and i create sheets/ webforms for all of them. I am wondering if it is possible to have different colors and logos for different sheets? We are currently running a rebate promotion using webforms for one of our brands so i want that brand's colors and logo on the sheet, however i need to…
-
Trying to do a group IF statment
Not sure how to ask this but I am trying to set up a tracking sheet that will automatically pull info from a master sheet. I would like to send out a form from for someone to fill out and all they would need to do is put in the job # into the form, and on the track sheet it will automatically fill in the rest of the…
-
Cell to test if an ETA has passed without an order delivery
Hello, I'm trying to generate a report that shows any orders that have passed their ETA without delivery. In the sheet, I have figured out how to highlight the row with conditional formatting, but I'd like to extract the order essentials into a report that I can surface to three different managers via a portal/dashboard.…
-
Stale time/date
Hi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of hours, then send a notification. I can compare two different date columns like this: =Modified1 - [Created Date]1 But if I…
-
Sync cells content according to date in different sheets
Hi there, I'm new to Smart Sheets and I'm trying to achieve the following. I'll try to explain. I have manually created a calendar, in normal grid mode, which has a 3 month view side by side with blanck cells next to each day where i can manually add content. I have another sheet, in card mode, where I can manage basic…
-
Auto-fill based on Column value
I have a drop down box containing staff member names, when selected I want it displayed automatically in the "Assigned to" column our company name. I have searched help but so far no luck, can someone assist? cheers.
-
Gantt Chart Start & Finsh dates Change
If my Start or Finsh date changes from the orginal schedule how can we show the progress or delay in the schedule. Currently I'm re-entering the Start or Finish date. So I'm lossing the orginal to show us any gains or losses. I do not want to loss the predecessors link to the task.
-
Auto-send PDF Gantt chart of project schedule
We want to be able to auto-send a PDF of projects to our clients on a weekly basis. Can we do this somehow? I know we could share a report for them to view at their own convenience, however, we can't be sure that they will log on to view it regularly which is necessary. to make it easier for them, we would like the option…
